The
enqueue_resources and db_file_multiblock_read_count init.ora
parameters are now self tuning and do not need to be set.
Streams
Pool Management Changes:
This
is now managed within SGA_TARGET.
RMAN
- Convert Database:
The
feature introduced to convert datafiles between operating
systems has been extended so that you can copy an entire
database with the RMAN “convert database” command.
Segment
Advisor:
This
now runs every night during the maintenance window along
with the statistics gathering job.
ASM
Command Line Utility:
You
can now interact directly with ASM files and disk groups
using the new ASMCMD command line tool. This uses Unix-like
commands for the manipulation of these files so you don’t
have to use SQL or the Enterprise Manager.
Direct
SGA Access:
In
the case of a hung system when you can’t even login,
the Grid Control software can attach directly to the SGA
and retrieve process and system information to help to troubleshoot
a problem.
Segment
Shrink Enhancements:
This
feature now supports LOBs.
Transparent
Data Encryption:
Data
can now be encrypted right down to the table level, meaning
only those with the right encryption key can even make sense
of data stored in a table.
Transportable
Tablespace:
Now
supports XML type.
Online
Table Redefinition:
Now
supports partitions, clusters, queue tables and object data
types.