WITH Clause Enhancements in Oracle 12c…

After doing a number of 12c installations, I decided it was time to write something new. I figured I’d pick something easy to start off with, so here is the first thing off the press.

Over the last year I’ve heard a few speakers talk about these enhancements, but I got myself into a right pickle while I was working through this. If you caught the first draft of this article you would see I made a complete mess of it and jumped to all the wrong conclusions.Β Having worked through it again with fresh eyes, it all became clear. Of course, if you didn’t see the first draft, then ignore what I said. The article has always been perfect. πŸ™‚

I think I will carry on doing some of the simple stuff to build my confidence before I can tackle something big, like pluggable databases. πŸ™‚

Cheers

Tim…

Update: Note to self. Searching the 11gR2 docs for “PRAGMA UDF” is unlikely to result in you finding this 12c feature. Who’da thunk it? Thanks to Tom Kyte for pointing me to the correct doc reference. I’ve altered the searches on my homepage to default to the 12c docs, so hopefully I won’t be such a Muppet next time. πŸ™‚

New scheduler stuff in 11gR2…

There are some nice new features in the scheduler in 11gR2. I’ve written about them here:

Remember, there was already a bunch of new stuff added in llgR1, so there’s a lot of whiz-bang stuff if you are moving from 10g.

I do think there are some real security issues with some of this stuff if it is used unwisely though. The remote jobs (external and database) just strike me as a disaster waiting to happen in the wrong hands. πŸ™‚

Cheers

Tim…

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…