Reclaiming Unused Space in Datafiles…

Most of the time I write about stuff I’m interested in, but occasionally I’m forced into writing something to prevent me answering the same question again and again. This is one of those moments and it’s been several years in the making. The last time I tried to muster up the enthusiasm was on a flight last year and I got so bored I fell asleep.

Well today I finally got round to putting it together, so next time I get asked something like,

“I’ve moved a table to a new tablespace, how do I free up the space in the original datafile?”

I can answer, read this:

If you already know the answer, please don’t read it. I don’t want to be responsible for you falling asleep at your desk and losing your job. 🙂

Cheers

Tim…

Grave Peril…

I was about 1/3 of the way through Fool Moon, the second book in the Dresden Files series, when the book went missing (insert Twilight Zone music here), so I switched to book 3 (Grave Peril) while I wait for Amazon to send me a new copy.

What with the illness and timezone change, I’ve spent a lot of time in bed not sleeping, so these books have come in very handy. I’ve now read 2 1/3 books in the series and I’m quite into them, so I’ve bought the rest of the series. Hopefully a delivery person will come knocking on my door tomorrow and I can get back to reading Fool Moon.

Cheers

Tim…

The Plague Plane…

It’s about 40 hours since I arrived back in the UK. Almost as soon as I got through the door I started to shiver so violently that I could hardly move. I eventually made it upstairs and got into the bath. Since that point my time has been spent switching between scalding hot baths and lying in bed fully clothed. The combination of the two went some way towards stopping me from feeling like I was going to freeze to death. I don’t think I’ve ever felt so cold whilst sweating so profusely.

I was feeling a little worried about going down stairs in case I got stuck there, but when I made my first trip life got a bit easier thanks to some Lemsip I found in the cupboard. This stuff is amazing. I think most General Practitioners could be replaced by a sign saying, “Take a Lemsip and go to bed you wimp!” I could pretty much tell when I was due for the next dose because my symptoms gradually started to return. I timed one trip a little badly and managed to throw about 1/4 of it down myself. Drinking hot drinks when you are shivering violently is not good for the complection. 🙂

This morning I feel significantly more normal. Still a bit sweaty and my head doesn’t quite feel like it belongs to me, but I so far no shivers. I do feel like I’ve had a mega-workout at the gym though. There have been some serious isometrics going on over the last couple of days. 🙂

So what do I put this down to? I could be wrong, but 24 hours in a plane full of people coughing seems like the prime suspect to me. As the hours went by the number of people coughing got bigger and bigger. By the time I boarded my last flight it sounded like everyone on the plane had TB.

Anyway, I’ve been upright for too long. I’m going back to bed.

Cheers

Tim…

Homeward bound…

My brief stay in New Zealand is coming to an end. Later today I will be getting on a plane to start my journey home to the UK. I can’t say I’m looking forward to the flights, but it has to be done…

Due to some bad planning on my part, I didn’t get to hook up with everyone I wanted to, but such is life.

The next NZOUG is about 18 months away. As I said before, I hope I get to come back again, but it’s a long way from home and you never know what life will through at you.

See you later…

Cheers

Tim…

NZOUG 2010 Day 2…

Day 2 started with an ACE panel session. There were more ACEs than attendees, but we all had fun chatting to each other. I guess one of the difficulties with this was it ran along side regular presentations, but such is life.

Straight after that it was the second part of my PL/SQL Presentation Layers session. Familiar faces from the day before and a couple of new people, although I think I did lose a few to Robert Freeman as I expected. I thought this session would finish early, but true to form I over ran and had to bolt through the last few slides. The blind panic at the end meant it didn’t feel as slick as I would have liked it to be, but that’s the price for trying to squeeze 120 minutes of content into 100 minutes.

I spent the rest of the day talking to people. I am blessed, or cursed depending on how you look at it, with the ability to talk to anyone and I just kept finding myself on conversations with various attendees and exhibitors about a whole variety of subjects. This is my favorite bit of going to conferences if I’m honest.

The day was wrapped up by an assortment of prizes from the sponsors, including a couple of people who got prizes for injuries sustained during the luge ride the night before. There was blood. 🙂

In the evening I went out for food with a few of the guys and we had a walk around the park, looking at all the thermal vents that spontaneous appear there. Lots of bubbling mud and water, along with a little cat sitting slap bang next to one. Cats are crazy.

So that’s the NZOUG conference over for another year. It was good fun and I hope I get to come back again, but with it being such a long way from home you never really know if it’s going to happen. Fingers crossed though.

Thanks to all the people on the NZOUG committee for making it happen and to all the attendees for coming. I hope to see you all again next time. Also, a big thank you to the Oracle ACE program for getting me down here. Without them this just wouldn’t happen.

Cheers

Tim…

Storm Front (The Dresden Files)…

One of the few advantages of such long flights as UK to New Zealand is you get plenty of time to read.

I’ve mentioned several times that I’ve struggled to find something to follow the Discworld series. Several people recommended The Dresden Files series so I went out and bought the first few books. I tried a couple of times to read the first book (Storm Front) and really couldn’t get into it. I brought the first 3 books with me, just in case I got bored, and fortunately for me it was a case of third time lucky.

I really enjoyed Storm Front and can’t believe it was the same book I gave up on two times before. Just goes to show how mood and circumstance has a big impact on your taste. I’m on to the second book (Fool Moon) now and so far so good.

Cheers

Tim…

NZOUG 2010 Day 1…

The day started in the normal way. First, an introduction by Francisco, the new president of NZOUG, then some keynotes, then on to the presentations…

One of the difficult things about being a speaker at so many conferences is you often struggle to see something on the agenda you have not already seen several times around the world (nice problem to have). As a result I side-stepped Dan Morgan’s first presentation because I had already seen it (or most of it) at OpenWorld. I’m sure it went down well because Dan is a natural speaker.

My first session of the day was Robert Freeman‘s. A quick romp through the Oracle features that have been around for ages, but you probably don’t know exist. You will struggle to find a nicer guy than Robert, so it’s always good to see him present. I kinda like this sort of presentation because because Oracle has such a lot of functionality, it’s easy to miss things. Robert has turned “to the dark side” and is now an Oracle employee. Come on Oracle. Stop poaching our ACEs. 🙂

I spent a lot of time during the day chatting to people (there’s a surprise). Plenty of familiar faces along with some new ones.

My session was the last time slot for the day. I’m doing a two-part session on PL/SQL presentation layers. I had a good turnout. It felt like it went well. I guess the real test will be how many people turn up for the second part, although I’ve just noticed I clash with Robert Freeman on my second slot, so when nobody turns up I can massage my ego by telling myself I was amazing, but Robert is famous. 🙂

In the evening we went over for the social event at the Skyline Skyrides. It was great fun going on the luge again. I learnt two lessons last year.

  1. You have to brake on the corners, or you die.
  2. You don’t enter the “carry a cup of water to the bottom” game unless you want to be ridiculed the whole evening for having a wet ass.

I remained alive and dry, so all was good.

After the luge rides came the dinner. Lots of food, lots of drinking (for those that do), comedian, party games and very little in the way of speeches. I think the NZ sponsors have got it right. Essentially it was, “Thanks for coming. Have a good night. Cheers”. Perfect. 🙂

This morning I’ve got a “Learn about the Oracle ACE Programme” session, followed by the second part of my PL/SQL presentation layers session. Then later in the afternoon I’ve got a “Meet the Experts” session. I’m interested to see what experts they’ve got for me to meet. 🙂

Cheers

Tim…

Arriving at NZOUG…

I walked off the 7 hour flight to Dubai, straight on to the 13+ hour flight to Melbourne. I got a 1 hour rest at Melbourne while they cleaned the plane, before I started the 3+ hour flight to Auckland. I got to Auckland at about 14:00 where I was met by one of my friends. I was whisked straight back to his house and spent the rest of the day catching up on everything that happened since my last skype call ( 4 days before 🙂 ) and playing with their kid.

The following day was mostly spent with a trip to some of my friends relatives and general idle conversation. Very low pressure. Very cool. The funny thing is, it’s about 18 months since I was last here and I feel like I never left. 🙂

This morning I got up early to pick Chris Muir up from the airport, where I bumped into Dan Morgan, not literally. Chris was delayed, so after a bit of messing about we got on our way to Rotorua. The roads were quiet so we made good time and I’m now in the hotel ready to go. We have a little get together tonight, then the conference starts tomorrow.

I guess I’ll do a run through of my presentations now, and maybe sleep a little later.

Cheers

Tim…

On my way to NZOUG…

Today is the day I fly to New Zealand to present at the NZOUG conference.

I got to the airport 2 hours before the flight as usual, but I’ve been here 3 hours already and I’ve still not boarded the plane. I have a long wait at Dubai, so this delay shouldn’t affect my connection. It’s 7 hours from Birmingham to Dubai, then 18 hours (including a fuel stop in Melbourne) to Auckland. I have a feeling I’ll look like “Dawn of the Dead” when my friend picks me up from Auckland Airport. I’ve not even started yet and I’m already kinda nervous. The thought of 18 hours on a plane is really getting to me. I only hope I can get some sleep on this trip.

It’s about 5 minutes to boarding now so I need to go through my last minute panic session before getting on the plane. 🙂

If there is ever another blog entry it means I made it. If not, it was nice knowing you all…

Cheers

Tim…