-
A Virtual Private Catalog can now make sure an
RMAN user can only see databases they are authorized to use.
-
Archive log management for Streams and Data
Guard
-
Network aware DUPLICATE
-
Optimized undo backup
-
Improved corrupt block detection
-
Java, PL/SQL, XML, .NET, PHP, APEX
-
PL/SQL Native Compilation without needing a
Third-Party C Compiler
-
Native PL/SQL use of Seq.Nextval in a
PL/SQL program
-
PL/SQL can use CLOBs to get around 32 KB
limitations of SQL character strings.
-
Enhanced PL/SQL warnings and error messages
-
PLSTIMER identifies hotspots and performance
tuning opportunities in PL/SQL.
-
New package DBMS_HPROF controls the
recording of raw PLSTIMER data.
-
Continued support of standards with JDBC 4.0
and JVM 5.0. Capability to upgrade to JVM 6.0 will be available in
the future.
-
Oracle JVM JIT supports transparent native Java
compilation without a C Compiler.
-
Significant performance improvements with JDBC
performance, especially with Advanced Queuing.
-
JDBC supports server side result cache along
with OCI client side result cache. Also included are big
improvements in the JIT and RAC support for JDBC.
-
New command line interface to OracleJVM,
thereby making it much easier to work with the JDK in the
database.
-
Support for database resident JARs
-
JDBC support for starting and shutting down the
database
-
Performance enhancements to XPath query for
Java
-
XML applications can now process larger XML
documents by loading and saving.
-
DOM nodes in memory and using a page manager
for physical binary data management
-
Unified Java API for XML allows mid-tier Java
programs to leverage lazily loading by allowing a disconnected
mode of operation that allows a XML Type to be used with a session
pool model of connection management.