Oracle 9i DBA Part 2

Course code: O920

5 days

This course is designed to allow experienced Oracle DBA's to fully utilise the 9i database architecture, and associated tools.

Course content >

Who Should Attend?

Everybody

Prerequisites

None

Course Contents

This course is designed to allow experienced Oracle DBA's to fully utilise the 9i database architecture, and associated tools.

We would recommend students who are not experienced to attend the O910 Oracle 9i DBA Part 1 course prior to attending this course.

The course fulfils the core advanced requirements Oracle's OCP DBA programme and also includes a fully featured introduction to Oracle's networking architecture.

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

Table Partitioning

Rules of Partitioned Tables and Indexes
Logical Attributes and Partitioning
Physical Attributes and Partitioning
Multicolumn Partitioning Keys
Updating Partition Key Values
Using the Equi-Partitioning Strategy
Using Partition Extended Table Names
Benefits of Partitioned Tables and Indexes

Partitioned Indexes

Prefixed Indexes
Non-prefixed Indexes
Local Indexes
Global Indexes
Unusable Indexes

Additional Partitioning

Hash Partitioning
Composite Partitioning
9i Partitioning Enhancements
Restrictions on List Partitioning

Partition Management

Commands
Alter Table/Index Commands
Supporting DBA Tables/Views
Changes to Plan Table, SQL Loader and Export/Import

Data Warehouse Features

Transportable Tablespaces
Index Organized Tables
Materialized Views

Security

Password Management
Enabling Password Management
Account Locking
Password Aging and Expiration
Password History
Password Complexity Verification
Data Dictionary Views
Default User Management
Fine Grained Auditing

ROWID

DBMS_ROWID
Logical ROWIDs

Large Objects

Comparing LOBs and LONGs
Internal LOBs
External Lobs
DBMS_LOB Package
TO_LOB

Advanced Queueing

Components of Advanced Queuing
AQ Implementation
AQ Administration
AQ Development
Data Dictionary Views
9i Network Architecture
Basic configuration
Networking Easy Configuration option
Listener administration
Using and configuring Oracle Names
Networking Wizard
Oracle Intelligent Agent
Installation
Configuration
Mixed SQL*Net and 9i Networking
Troubleshooting

Connection Manager

Concentrators
Multiplexing
Connection pooling
MTS
Using multi-threaded server
Configuration
Restrictions
Security
Oracle Security Server
3rd Party options
Private and Public encryption
TNS Raw

Performance & Scalability

Bitmap Indexes
Reverse Key Indexes
Function Based Indexes
Other index changes
Table move command
Temporary tables
Drop columnPlan Stability: Stored Outlines
DBMS_STATS Package
ETL Performance Enhancements
Database Object Enhancements
Additional Performance Improvements
Real Application Clusters

Development

Deferred Constraints
Enforced Constraints
Extended SQL: Analytical Functions
9i Development Platform

Availability & Recoverability

FlashBack Query
Online Data Evolution
Bounded Recovery Time
9i Availability / Recoverability
Multiple, Remote Archival of Redo Logs
Automated Standby Databases
Oracle DataGuard
Corrupt Block Detection and Repair
LogMiner
9i Additional Features
Recovery Manager

Oracle Tools/Utilities

Enterprise Manager and DBCA