Improved 11g managementRepository enhancements

Advanced 11g advisors

Interval partitioning for tablesNew load balancing utilitiesWeb server load balancingListener Load Balancing

New table Data Type “simple_integer”Improved table/index compressionFaster DML triggersImproved NFS data file managementServer side connection poolingScalability EnhancementsScalable execution

Virtual columns

“super” object-oriented DDL keyword

Oracle 11g XML data storage

New Trigger features

Partitioning by logical object and automated partition creation.

New high-performance LOB features.

Incident Packaging Service (IPS)

Feature Based Patching

Enhanced Read only tables

Table trigger firing order

 

 

 

RAC instance load balancingOracle 11g RAC parallel upgradesOracle RAC load balancing advisorADDM for RACOptimized RAC cache fusion protocolsOracle 11g RAC Grid provisioningHot patching

Standby snapshot

Quick Fault Resolution

 

 

Interfaces to ApplicationsOEM Easy de-installDatabase repair wizardBetter OEM Grid tools

 

PHP - Improved PHP driver for Oracle.PL/SQL “continue” keywordDisabled state for PL/SQLImproved native Java & PL/SQL compilers.Easy PL/SQL compilingOracle 11g XML EnhancementsImproved PL/SQL stored procedure invalidation mechanism

Scalable PL/SQL and Java

Improved sequence management
 

 

 

Intra-unit inliningEnhanced PL/SQL warningsNamed notation

The /*+result_cache*/ SQL hintXML SQL queriesSQL ReplayImproved optimizer statistics collection speedSQL execution Plan ManagementDynamic SQLFully Automatic SQL Tuning

Improved SQL Access Advisor

 

 

 

11g SQL Performance Analyzer (SPA)
 

11g Multi-column hybrid histograms

 

CBO correlating statistics

 

New Oracle11g Advisors
 

Automatic Diagnostic Repository (ADR)Automatic Memory TuningResource ManagerADDM for RACFaster sortingAWR BaselinesAdaptive Metric Baselines

 

 

Database Replay
 

Secure PasswordsAuditing Defaults in 11gDatabase Administrator Security SetupTransparent Data Encryption (TDE) enhancementsTDE and LogminerEncrypted TablespacesEncrypted LOB columns using Oracle SecureFiles

Hardware Secure Module versus Oracle Wallet

TDE and Logical Standby Database

FGAC for UTL_SMTP, UTL_TCP and UTL_HTTP

EM new Security Features

Policy Manager

Label Security Administration in EM

Enterprise Users Administration

VPD configuration

Application Contexts configuration
 

 

 

Data Guard Load Balancing
 

Data Guard supports “Flashback Standby”.
 

RAT - Real Application Testing
 

- SQL Performance Analyzer (SQL Replay)- SQL Plan Manageability (SQL Plan baselines)- Database replay
- The technology behind it- capture workload- replay workload on test system- analyze replay (compare periods)- Using EM for replay database

 

 

What’s new about UNDO and transactions in 11g?Optimized UNDO BACKUPTracking transactional changes on tables over its lifetime by using FLASHBACK DATA ARCHIVEThe technology behind itEnabling Flashback Data ArchiveViewing Flashback Data Archive InformationDDL limitations for Flashback Data Archive

Flashing back transactions:

using DBMS_FLASHBACK

using 11g OEM for flashback transaction
 

 

 

ASM Fast Mirror ResyncASM Preferred Mirror ReadASM Performance EnhancementsASM Disk Group Checks enhancedASMCMD new featuresSYSASM role in 11g