Loading...

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
Contact us for more information