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 [...]
¶
Posted 19 February 2008
† Tim...
§
Oracle
‡
°
Also tagged: 11g, adaptive cursor sharing, ddl_lock_timeout, enhancements, fine grained dependency management, invisible indexes, ocp, online table redefinition, Oracle, query result cache, temporary tablespace
On the surface, the changes to PL/SQL look rather minor, but there is some seriously cool stuff in there. I originally intended to write a single article, but some sections got too big so I thought it was worth sectioning them out into separate articles.
PL/SQL New Features and Enhancements in Oracle Database 11g Release 1
Cross-Session [...]