Session 1: NEW MANAGEMENT FEATURES
- Log File Changes
- Parameter File Management Changes
- Automatic Diagnostic Repository
- ADRCI Command Line Tool
- New Memory Management Features
- Memory Advisor Views
- New Management Parameters
Session 2: INSTALLING ORACLE DATABASE 11g
- System Hardware requirements
- Overview of Oracle Grid Infrastructure
- Installing Oracle Database 11g Release 2
- The Database Configuration Assistant
- Database Templates
- Online Patching
Session 3: UPGRADING TO ORACLE DATABASE 11g
- Upgrading to Oracle Database 11g Release 1 and 2
- Upgrade the Time Zone File and Timestamp with Timezone Date
- Oracle Parameter Changes
- Altered Parameter Behaviour
- Online Dictionary View Changes
Session 4: ADMINISTER A DATABASE
- Administrative Tools Available to a DBA
- Use Oracle Enterprise Manager to Manage a Database
- Stop and Start the EM Database Console
- Access Oracle Enterprise Manager
- Grant EM Administrative Privileges
- Control Oracle Restart
- Use the srvctl Utility
- Manually Add Components to the Oracle Restart Configuration
Session 5: NEW DATABASE STORAGE FEATURES
- Default Permanent Tablespace
- Rename a Tablespace
- The SYSAUX Tablespace
- Copy Files Using the Database Server
- Drop an Empty Datafile
Session 6: SECURITY ENHANCEMENTS
- Connect Role Change
- Default Passwords
- Automatic Secure Configurations
- Case Sensitive Passwords
- Profiles and the Password Verify Function
- Virtual Private Database Enhancements
- Auditing Enhancements
- OS Audit in XML Format
- Uniform Audit Trail
- Default Auditing in Oracle Database 11g
- Tablespace Master Key Re-key
- DBMS_CRYPTO
- Transparent Data Encryption
- Transparent Tablespace Encryption
- Data Masking
- Security and OEM
Session 7: AUTOMATIC DATABASE MANAGEMENT
- Automatic Workload Repository
- AWR 11g New Features
- Automatic Database Diagnostic Monitor
- ADDM 11g New Features
- ADDM Reports
- DBMS_ADVISOR Reports
- DBMS_ADVISOR Views
- Alerts
Session 8: AUTOMATING TASKS WITH THE SCHEDULER
- Scheduler Overview
- DBMS_SCHEDULER
- Scheduler Related Parameters
- Access Rights
- Create a Program
- Enable a Program
- Drop a Program
- Create a Schedule
- Create a Job
- Job Classes
- Resource Windows
- Window Group
- Monitoring and Logging
- AutoTask
Session 9: SCHEMA MANAGEMENT NEW FEATURES
- DDL Wait Option
- Add Columns with a Default Value
- Virtual Columns
- Invisible Indexes
- Improved Online Index Creation and Rebuild
- Read Only Tables
Session 10: APPLICATION DEVELOPMENT NEW FEATURES
- Append, Create and Replace Extensions to Spool/Save
- SQL*Plus Errorlog Table
- Lock Table Parameter
- SQL Query Result Cache
- Client Side Result Cache
- PL/SQL Function Cache
Session 11: UTILITIES FOR TROUBLESHOOTING DATA CORRUPTION
- Automatic Block Corruption Reporting
- Automatic Quarantine of Corrupt Undo Segments
- Protection from Data Corruptions
- Improvements to ANALYZE ... VALIDATE STRUCTURE
- Proactive Monitoring with the Health Monitor
- Session 12: BACKUP AND RECOVERY NEW FEATURES
- Recovery Through Reset Logs
- Changes to ALTER DATABASE ARCHIVELOG
- Recovery Manager Enhancements
Session 13: DATA RECOVERY ADVISOR
- Overview of Data Recovery Advisor
- Use the Data Recovery Advisor through the RMAN Command Line
- Run Pro-Active Health Checks with the Validate Command
- Use the Data Recovery Advisor through EM
- Automatic Diagnostic Repository
- Data Recovery Advisor Dictionary Views
Session 14: OVERVIEW OF AUTOMATIC STORAGE MANAGEMENT
- Overview of ASM
- ASM Instance Creation
- SYSASM Role
- Administer ASM Disk Groups
- ASM Files
- ASM Startup and Shutdown
- ASM Disk Failure
- ASM Data Dictionary Tables
- Migrate a Database to ASM Using RMAN
- The asmcmd Command Line Interface
- ASM File Access Control
- Use 4KB Sector Disks
Session 15: DATABASE REPLAY
- Overview of Database Replay
- The Database Replay Process
- Capture a Workload
- Pre-process the Captured Workload
- Replay the Workload
- Database Replay Usage
- The DBMS_WORKLOAD Package
Session 16: DATA PUMP
- The exp Utility Deprecated
- Introduction to Data Pump Import and Export
- Data Pump Architecture
- Data Pump Export
- Data Pump Import
- Data Pump Legacy Mode
Session 17: OVERVIEW OF DATA GUARD NEW FEATURES
- Apply Redo in Real Time
- Redo Transmission Enhancements
- New Standby Database Parameters
- ARCH Process Writes to Standby Redo Logs
- Changes to Standby Database Startups
- Logical Standby Database Enhancements
- Fast Start Failover Enhancements
- Archive Redo Log Compression
- Lost Write Detection
- Real Time Query Capable Physical Standby Database
- Rolling Upgrades to Physical Standby
- SQL Apply Logical Standby
- RMAN and Data Guard
- Snapshot Standby Databases
- Clone a Running Database
- Active Database Duplication
- Oracle Active Data Guard
- Real Time Query
- Block Change Tracking on a Physical Standby Database
Session 18: ORACLE DATABASE ADVISORS
- Repair Advisors and Fault Diagnostics
- The SQL Repair Advisor
- The SQL Access Advisor
- The Streams Performance Advisor
- The Advisor Views
Session 19: FLASHBACK TECHNOLOGY
- Flashback Query
- Flashback Version Query
- Flashback Table
- Flashback Transaction Query
- Flashback Drop
- Flashback Database
- Flashback Restore Points
- Flashback Transaction Backout
- Enterprise Manager Log Miner Interface
- Flashback Data Archive
- Oracle Total Recall
Session 20: DIAGNOSTICS NEW FEATURES
- Oracle Database 11g Fault Diagnostic Automation
- Automatic Diagnostic Workflow
- Problems and Incidents
- Incident Packaging Service
- EM Support Workbench Overview
Session 21: PERFORMANCE TUNING NEW FEATURES
- Rule Based Optimizer Obsolescence
- Automatic Statistics Collection
- Improved Statistics Gathering
- Direct SGA Access
- Application and SQL Tuning
- SQL Tuning Advisor
- SQL Access Advisor
- Real-Time SQL Monitoring
- View the SQL Monitoring Report
- SQL Performance Analyzer
- Intelligent Cursor Sharing
- SQL Plan Management
- Temporary Tablespace Shrink
- Test Case Builder
- New Hints
- View Session Details
Session 22: DATA WAREHOUSE AND BI NEW FEATURES
- Partitioning Enhancements
- Materialized View and Query Rewrite Enhancements
- The PIVOT and UNPIVOT Clauses
- Data Compression
- Parallel Query New Features
- Resource Manager New Features