11g Features

Oracle 11g New Features for Database Administrators (DBA)

1.Installation, Database Upgrades and Change Management
• Installation New Features Support
• Role and Privilege Changes
• Deprecated Components
• New Initialization Parameters Affecting Database Creation
• DBCA Enhancements
• Upgrading to Oracle Database 11g
• Database Replay
• The SQL Performance Analyzer
• Patching in Oracle Database Control

2.Database Diagnosis and Repair
• Introducing Automatic Diagnostic Repository (ADR)
• Configuring the ADR
• Using adrci Tool
• Using The Support Workbench in the OEM
• Database Health Monitor
• Data Recovery Advisor
• SQL Test Case Builder
• Data Block Corruption Parameters

3.Database Administration
• Automatic Memory Management
• Automatic Maintenance Tasks
• Oracle Flashback-Related New Features
• Flashback Data Archive
• Oracle Flashback Transaction Backout
• Virtual Columns
• New Data Partitioning Schemes
• DDL Lock Timeout
• Explicit Locking of Tables
• Invisible Indexes
• Read-Only Tables
• Shrinking Temporary Tablespaces and Tempfiles
• Creating an Initialization Parameter File from Memory
• Restore Point Enhancements
• Database Resident Connection Pooling
• Comparing and Synchronizing Database Objects
• SQL*Plus New Features
• Online Application Maintenance
• Oracle Advanced Compression Option
• Oracle Scheduler New Features
• Lightweight Jobs
• Remote External Jobs
• Finer-grained Dependency Management
• Enhancements in Oracle Database Resource Manager

4.Performance Tuning
• PL/SQL Native Compilation
• Server Result Cache
• Client Side Result Cache
• Enhanced Oracle Process Monitoring
• Subprogram Inlining
• SQL Tuning Automation
• SQL Access Advisor Enhancements
• Changing Statistics Preferences
• Enhanced Statistics Maintenance
• SQL Plan Management
• ADDM New Features
• AWR New Features
• Setting Metric Thresholds for Baselines
• Performance-Related Changes in Database Control
• Miscellaneous New Performance Tuning Features
• Real-Time SQL Monitoring

5.Database Security
• Stronger Password Hash Algorithm
• Security Out of the Box
• Anti Network Attacks Parameters
• Tablespace Encryption
• Fine-Grained Access Control for UTL* Packages
• Further Security New Features

6.Backup and Recovery New Features
• Enhanced Block Media Recovery
• RMAN Substitution Variables
• New RMAN Configuration Parameters
• The Multisection Backups
• Creating Archival Backups
• VALIDATE Command
• Configuring an Archived Redo Log Deletion Policy
• Active Database Duplication
• Importing and Moving Recovery Catalogs
• Virtual Private Catalogs
• Miscellaneous New Features in RMAN

7.Data Pump Utilities
• Compression Enhancement
• Encryption Enhancements
• Reusing a Dump File
• Remapping Data
• Renaming Tables During Export or Import
• Data Pump and Partitioned Tables
• Ignoring Nondeferred Constraints
• External Tables Based on Data Pump Driver
• Enhancement in the Transportable Parameter

8.Automatic Storage Management (ASM)
• SYSASM Privilege and OSASM Group
• Upgrading ASM using DBUA
• Upgrading ASM Manually
• ASM Restricted Mode
• Diskgroup Attributes
• Checking Diskgroup
• asmcmd Utility Commands
• Fast Rebalance
• Miscellaneous ASM New Features

9.PL/SQL New Features
• PL/SQL New Features

10.Data Warehousing
• SecureFiles
• Accessing a LOB Using SQL and PL/SQL
• Online Redefinition
• Partition Change Tracking (PCT)
• PIVOT Operator Enhancements
• Partitioning Improvements