Small World

On the way out to teach this class, I ran into a coworker from the last company I worked with. He actually used to be my boss. He sat in front of me on the plane from PHL to SFO, so that was cool. It’s always nice to be with someone you know in an airport – you can leave your stuff with them while you go to the restroom.

Then, on the way back home, flying out of LAX, I saw in the distance someone I thought I knew. I figured it couldn’t be him, so I let him walk away. Then I thought “If that’s him and I didn’t chase him down, I’ll be mad”. So I followed him, and yes, it was a friend we knew from PA, who moved to IN years ago. We’ve kept in touch, but it was great to run into him by chance like that.

Getting Clear on FLASHBACK

During the teaching of the DBA I workshop this week, I've had something greatly clarified - by the observing instructors there - thanks Tony Woodell and Larry Baumann. It has to do with Flashback technology, and what the underlying supporting data is for making each of them happen. It's good to know this, because it helps to keep straight what each flashback command (well, they're not all "commands", either) is doing for you.

Flashback technology  What it uses
--------------------  ------------
Flashback Database    Flash Recovery Area
Flashback Table       Undo
Flashback Drop        Recycle Bin
Flashback Query       Undo
Flashback Version     Undo
Flashback Transaction Undo

It's also good to keep clear that the first three *change* data in the database. The last 3 are simply add-on clauses, or different way to *select* - the flashback is just done on the fly, so you can reach back in time and retrieve the data you're after, for the time you specify. The recycle bin is a great thing, but keep in mind that it isn't really an area of storage that you set up in any way. As tables are dropped, they are renamed, and thus hidden, in a way. As long as they are not PURGEd (either by manually issuing the PURGE clause at drop time, or automatically when there is space pressure) then the table is still considered to be in the recycle bin. And, mind you, there is no way to guarantee how long a table sticks around in the recycle bin, so don't depend on it in your design. The class is over - it went very well, and now we have a lot of good feedback to work back into it before it gets out the door.

DBA Class

I'm co-teaching an Oracle DBA class this week. Loving it. A co-worker and I rewrote, and upgraded to 10gR2 - this DBA workshop.

I really love that there are some newbies in the class. And the best part is, they are SO engaged. One of them often says out loud "I love this class". And then talks about getting certified, etc.

This is fun.

During this rewrite, I've enjoyed the challenge of coming up with some lab exercises that more reflect a DBA's real world. Lead them into an error situation - hint at how to get out of it, fix it, etc.