11g bits and bobs…

I’ve just released an article covering the Miscellaneous New Features section of the OCP upgrade exam. It contains a rather random assortment of stuff including:

  • Online Table Redefinition Enhancements
  • Enhanced Finer Grained Dependency Management
  • DDL With the WAIT Option (DDL_LOCK_TIMEOUT)
  • Invisible Indexes
  • Query Result Cache
  • Adaptive Cursor Sharing
  • Temporary Tablespace Enhancements

I was toying with the idea of putting each section out as separate articles, but they’re all pretty small soundbites, so I thought I would be better to stick with grouping in the OCP syllabus.

Cheers

Tim…

RMAN Enhancements in 11g…

My trip through the 11g new features continues with RMAN Ehancements. These combined with the Data Recovery Advisor and Flashback and LogMiner Enhancements I wrote about previously show that Oracle are really putting a lot of effort into getting this area right. I guess the Data Recovery Advisor will be the most outstanding new feature for most people, but there are loads of tweaks all round that all help to make life easier for us guys on the coal face.

Cheers

Tim…