Objectives
The course is designed for a technical person who is already experienced in Oracle database administration or development and will enable the delegate to utilise the improvements made in the 9i architecture.
Course Content
Course content has been developed for real-world, commercial scenarios by our expert instructors. See below for detailed syllabus, or if you have a technical query email .
Duration
5 Days- full course
2-3 day course for DBAs
2-3 day course for Developers
Who Should Attend
The course is suitable for experienced database administrators, system administrators and support staff.
Pre-Requisite Skills
Delegates should have a good knowledge of their operating system, SQL*PLUS and PL/SQL and the Oracle database.
What You Will Learn
1. Understand the Oracle 9i architecture.
2. Understand and implement the new features of Oracle 9i.
3. Utilise the enhancements to Oracle SQL.
Associated Course(s)
Oracle Server Security
· Utilizing Advanced Security Features
SQL Enhancements
· Creating CROSS, NATURAL, INNER, and OUTER Joins
· Utilizing Other New SQL Features
· Embedding SQL Changes in Other Languages
File Management
· Utilizing Oracle Managed Files
· Managing Default Temporary Tablespaces
· Creating and Maintaining Server Parameter Files
Tablespace Management
· Managing Multiple Block Sizes
· Supporting Automatic Undo Management
Online Operations
· Rebuilding Indexes Online
· Re-Organizing Indexed Organized Tables Online
Segment and Index Management
· Creating Segments with Automatic Free Space Management
· Maintaining Global Indexes
· Managing External Tables
· Partitioning Tables with the LIST Option
Performance Improvements
· Enabling and Disabling Index Usage Monitoring
· Reducing Index Requirements with Index Skip Scanning Optimisation
· Utilizing Cost Based Optimiser Improvements
General High Availability Technology and Fault Recovery
· Selecting High Availability Options
· Recovering from Errors and Faults with Oracle Flashback, Resumable
Statements, and DBVerify
Database Resource Manager Enhancements
· Establishing an Active Session Pool
· Configuring Automatic Consumer Group Switching
· Modifying Undo Quota
Scalable Session State Management
· Managing External Procedure Agents
· Managing Multi-Threaded Heterogeneous Services
Real Application Clusters
· Defining Real Application Clusters and Cache Fusion
· Creating a Common Initialization Parameter File
· Configuring Oracle Parallel Fail Safe
Memory Management
· Managing PGA Memory
· Sizing SGA Components Dynamically
· Measuring Latch Contention
Oracle Enterprise Manager And DBA Studio
· Using the Enterprise Manager Configuration Assistant
· Understanding the DBA Studio
Globalisation Support
· Setting Time Zone Parameters
· Using New Data Types with Fractional Second Support
· Manipulating NLS Data with the Oracle Locale Builder
Backup and Recovery
· Implementing Recovery Manager (RMAN) Automatic Channel Allocation
· Utilizing RMAN Enhancements
· Incorporating Improvements to Standby Database Management
· Implementing Application Fail Over
Oracle9i LogMiner Enhancements
· Examining DDL Statements with LogMiner
· Examining Only Committed Transactions with LogMiner
· Utilizing Other New LogMiner Features
High-Availability Options
· Identifying Oracle Fail Safe Enhancements
· Configuring and Using Oracle9i Data Guard
Advanced Replication
· Implementing Row Level System Change Numbers
· Utilizing Extended Availability Features of Advanced Replication
· Implementing Materialized View Enhancements
· Incorporating Job Queue Changes for Replication
|
|
|