Through hands-on experience in administering an oracle 9i Database you can understand the Oracle Server architecture, expand the size of the database, implement security, and know why and how specific database administration tasks are performed.
This course is not available as part of our public schedule but can be provided on a customised client specific basis.
Knowledge of SQL
Introduction to Oracle 9i SQL and SQL *Plus course or equivalent experience
Introduction to oracle 9i PL/SQL course or equivalent experience is highly recommended.
Introduction and Duties of the DBA:
Oracle RDBMS Components
Tables, Constraints and Indexes:
Introduction to Datatypes and Tables
Temporary tables, partitioned tables (range, hash, list), external tables, IOTs
Indexes and Skip Scanning
Database workspace management
Other Database Schema Objects:
DDL Commands used
Views, Materialised views
Sequences, Synonyms, Database Links
Outlines, Dimensions, Hierarchies
PL/SQL Program Units
Oracle Data Dictionary
Storage of Large Objects (BFILEs, BLOBs, CLOBs)
Starting and Stopping the Database:
What Tool to Use?
Connecting as a Privileged User
Password file authentication
Starting and Shutting Down a Database
Reading the Alert Log / Trace Files
Quiescing the database
SPFILE / Parameter management
How Space is Physically Consumed - Blocks and Extents: