Course Contents
This course is designed to introduce the new features and enhancements in Oracle 9i database.
The course has been designed for existing DBA's, familiar with previous versions of Oracle's family of RDBMS products (7, 8, 8i).
The course fulfils the need of DBA's to remain up to date with new 9i development as well as considering the im-pact/opportunities available through the implementation of Oracle 9i within an existing Oracle business infrastructure
Training Course Contents
Manageability
- Locally Managed Tablespaces
- Multiple Block Sizes
- Memory Management
- Automatic Segment Management
- Instance Management
- Monitoring Index Usage
- Default Temporary Tablespace
- Metadata API
- Automatic Undo Management
- Oracle Managed Files
- Persistent Parameter Files
- Resumable Space Allocation
- DBMS_RESUMABLE Package
- 9i Partitioning Enhancements
- Default User Management
- Fine Grained Auditing
Performance & Scalability
- ETL Performance Enhancements
- Bitmap Join Indexes
- Database Object Enhancements
- Additional Performance Improvements
- Real Application Clusters
ISQL
- Configuration
- Connecting
- Customising
- Work Screen
- History
- Preferences
- SQL for DBA Commands
Development
- CURSOR_SHARING parameter
- 9i Development Platform
Security
- Oracle 9i Virtual Private Database Feature
- Fine-grained Auditing
- Secure Application Role
Availability & Recoverability
- FlashBack Query
- Online Data Evolution
- Availability and Recoverability
- Multiple, Remote Archival of Redo Logs
- LogMiner Enhancements
- Recovery Manager
- Configurable Parameters
- Block Level Recovery
- SPFILE and Controlfile Backups
Oracle Data Guard
- Data Guard Features
- Network Configuration
- Creating the Standby Database
- Failover without Data Guard
- Failover Using Data Guard
- Role Transitions Using Data Guard
- Data Guard Protection Modes
- Logical Standby Databases
- Restrictions on Logical Standby Databases
- Creating a Logical Standby Database
- Logical Standby Failover and Switchover
- Data Guard Manager
Oracle Tools/Utilities
- Enterprise Manager and DBCA