Oracle Database 11g Release 2 is the latest in a long line of Database platforms from Oracle.

Oracle 11g offers stability, high functionality and scalability for all your organisation’s enterprise data needs.

Our Oracle 11g DBA New Features training course aims to give experienced Oracle DBAs a comprehensive, intensive hands-on introduction to the core features and best implementation practices.

 

• Upgrade considerations
• Oracle Database Replay
• Oracle Enterprise Manager
• Oracle 11g Database Security
• Backup and Recovery
• Resource Management
• Oracle 11g Database Storage Structures
• Automatic Storage Management (ASM)
• Managing Database Space

Anyone who needs to have a strong understanding of the new features of Orale 11g from a DBA perspective - looking after optimisation, security, and backup / disaster recovery scenarios.

Delegates should have exeperience of administrating previous versions Oracle databases. If you're looking to cross-train from another database such as SQL Server or Sybase, please let us know so we can look at getting you up to speed as quickly as possible.

Introduction to Oracle 11g

Oracle Architecture Overview / Refresher
Upgrade Considerations & Methods

Upgrading to 11g

Backing up before upgrading
Installing & Patching Oracle 11g
Using DBUA
Pre-upgrade and Post-upgrade tools
Create a test Database
Server Manager scripts
Character Conversions
Unusable Function-based Indexes
The Recovery Catalog

Oracle Database Replay

Workload Capture
Workload Replay
SQL Performance Analyzer

Oracle 11g Enterprise Manager (EM)

Database Control
Grid Control
Administrative Privileges
Managing the environment with Grid Control
Preferred Credentials

New Database Maintenance Features

Automatic Workload Repository
Job Scheduler
Alerts
Advisor Framework
Diagnostic Monitor

Oracle 11g Database Resource Management

Allocation methods
Maximum Estimated Execution Time
Automatic Consumer Group Switching
Statistics
Automatic Memory Management
Configuring Parameters
Monitoring

Oracle 11g Database Storage Structures

Tablespaces - varieties and usage
Oracle Managed Files (OMF)
Nonstandard Block Sizes
Monitoring Tablespaces
Redo Logfile Sizing Advisor

Automatic Storage Management (ASM)

ASM Architecture
Accessing an ASM Instance
ASM Administration
Parameter Changes
Migrating to ASM

Managing Database Space

Undo Advisor
Undo Management
Configuring Parameters

Oracle 11g Database Security

Default User Accounts
Password Best Practices
Access hierarchy
Fine-Grained Auditing
Audit Trail

Schema Objects

Segment-space Management
Object Privileges
Redefining Tables
Data Segment Compression
Segment Advisor

Data Import / Export

Data Pump
External Tables
Transportable Tablespaces

Backup and Recovery

Backup & Recovery with RMAN
Incremental Backups
Backup compression
Encrypting backups
Flashback Transaction Query
Recovering data, trasactions & logs with Flashback
LogMiner Enhancements

Oracle SQL Performance & Tuning

SQL Tuning Advisor
SQL Access Advisor
DBMS_MONITOR

Troubleshooting

Fault Management
Automatic Diagnostic Workflow

Automatic Flashback Transaction QueryDiagnostic Repository

Health Checks
SQL Repair Advisor
Viewing, Disabling, or Removing a SQL Patch

Related courses