Segment Creation on Demand (Deferred Segment Creation) in Oracle 11.2.0.2…

It looks like 11.2.0.2 has improved most of the original shortfalls of segment creation on demand that were present in 11.2.0.1.

Cheers

Tim…

Direct NFS (DNFS) Clonedb…

A bit before Christmas I got an email from Kevin Closson asking me to take a look at a new undocumented Direct NFS (DNFS) feature in the 11.2.0.2 patch set. I think he wanted to see what a regular DBA would think of it. What with Christmas and some family issues, I didn’t get too much done. As soon as I hit the first hurdle I kinda caved in and left if for the new year.

Well, January came and went, then I finally got round to looking at it again. I like to think my constant questions and dumb mistakes has helped to prepare Oracle for the sort of thing that will happen when other idiots like me are let loose on it. Anyway, the result of that little journey is documented here.

As I’ve said in the article, things are still in a state of flux and I will no doubt have to do some alterations once the My Oracle Support (MOS) Note 1210656.1 is released that will properly document it.

So as a regular DBA what do I think? I think it is awesome!

Old-style cloning of databases isn’t hard, but it’s boring and can take ages depending on the size of the database and storage being used. It’s one of those tasks that always makes me sigh, before I get off my ass and start it. Clonedb turns that on its head because it is really quick and simple. There is a bit of setup, but that is really going to be a one-time thing on most servers. You are doing your backups anyway, so there is no big deal there. Now you can just run a script and bang, you have a running clone.

I think this is going to please a lot of DBAs out there!

Cheers

Tim…

Oracle DB 11.2.0.2 patch set is here … Again…

The incredible disappearing patch set has reappeared on MOS. Download it quick before it gets pulled again. :)

Cheers

Tim…

PS. Remember, read the patch note before you download it. You don’t need all 4.8G. Also, check out the new recommended patching instructions.

The disappearing 11.2.0.2 patch set…

Last week there was a little episode where the 11.2.0.2 patchset was released, as noted here:

Many of us started downloading it. Some (like me) got a full download, while others got cut off part way through when the patch was pulled from MOS. Someone on twitter mentioned the patch is scheduled for an October release (can’t find the tweet now), so I guess it was put live by accident. Who knows what changes, if any, will happen between now and then, so I would suggest that anyone who managed to get hold of the patch redownload it when it is eventually released, just in case they miss something important. Having said that, the OUI now checks for updates, so it is probably safe.

Even though the patch set is not on general release at the moment, there is plenty of information available to get yourself ready for it.

Cheers

Tim…