Oracle Database 11g New Features


Oracle 11g New Features:

Oracle 10g and 11g differences.

■Adaptive Cursor Sharing.

■ADDM Enhancements (for RAC).

■Automated Maintenance Tasks.

■Automatic Memory Management.

■Automatic SQL Tuning .

■Automatic Storage Manager (ASM) Enhancements.

■AWR Baseline Enhancements .

■Case Sensitive Passwords .

■Data Recovery Advisor .

■Database Resident Connection Pool .

■Database Replay .

■DDL With the WAIT Option (D…DL_LOCK_TIMEOUT) .

■Diagnostics Repository .

■Direct NFS .

■Fine-Grained Access to Network Services .

■Finer Grained Dependency Management .

■Flashback Data Archive .

■Flashback Transaction .

■Function Result Cache .

■Health Monitor .

■Installation – Oracle Database 11g .

■Invisible Indexes .

■Logminer .

■Online Table Redefinition .

■Partitioning .

■Query Result Cache .

■Read-Only Tables .

■Resource Manager Enhancements .

■RMAN .

■Scheduler Enhancements .

■SecureFiles .

■SQL Access Advisor .

■SQL Performance Analyzer.

■SQL Plan Management .

■Statistics Collection Enhancements .

■Table Compression Enhancements .

■Temporary Tablespace Enhancements .

■Tablespace Encryption .

■Upgrading to Oracle Database 11g .

■Automatic Subprogram Inlining .

■Compiler Warning .

■CONTINUE .

■DBMS_XA .

■Data Pump Enhancements .

■Dynamic SQL .

■Generalized Invocation .

■Hierarchical Profiler .

■Native Compilation .

■Native XML DB Web Services .

■Notation .

■PIVOT .

■PL/Scope.

■Regular Expressions .

■Sequences .

■SIMPLE_INTEGER .

■Triggers .

■UNPIVOT .

■Virtual Columns .


Nagulu Polagani

"We are all apprentices in a craft where no one ever becomes a master."

Comments