Oracle9I Database Administration – DBA I Course

This course provides a starting point for administration of the Oracle database. The first 2-day segment considers an in-depth discussion of the database architecture, including the Oracle instance, background processes, the SGA and memory structures, data files, tablespaces, extents, blocks and rows. Common administration tasks are also considered such as security, backup & recovery, physical storage of indexes and tables and many others.

This course can also be called “Oracle9i Database Architecture & Administration – DBA I”.

This course is designed for Oracle database administrators.

Upon completion of this course, the participant will be able to:
> Install, startup and shutdown an Oracle database
> Explain the internal architecture of data, memory and process structures
> Administer a security policy for the database
> Configure a basic backup & recovery strategy
> Control physical storage of tables and indexes
> Build efficient databases with clusters and bitmap indexes

The Oracle Database Environment 
Application Architectures
The Oracle Database 
Components Of A Database 
Instance Configurations 
About The Administration Tools
Memory Structures Within The Instance 
Parameters Which Determine SGA Size 
Instance & User Processes 
Instance Background Processes 
SQL Execution Processes 
Installation & Database Creation 
Database Administrator Authentication 
Pre-Installation Tasks 
Post-Installation Tasks 
Instance Startup & Shutdown 
Database Startup 
Database Shutdown 
Restricted Sessions 
Database Files 
Dynamic Instance Configuration 
Dynamic Parameter Changes 
Determining The Scope Of Changes 
Viewing Parameter Values 
Using Locally-Managed Tablespaces 
About Tablespace Maintenance 
Locally-Managed Tablespaces 
Temporary Segments & Tablespaces 
The Optimal Flexible Architecture 
Using Dictionary-Managed Tablespaces 
Dictionary-Managed Tablespaces 
Migrating The Tablespace Management Method 
Managing Data Files 
The Storage Hierarchy 
Exploring The Physical Storage Hierarchy 
Managing The Data Files 

Managing Redo Logs 

Automatic Undo Space Management 
Configuring Automatic Undo Space Management 
Tuning Automatic Undo Space Management 

Implementing Oracle Managed Files 

Managing Users 
User Management 
About Privileges 
Resource Limits Via Profiles 
Password Management Via Profiles 

Managing Privileges Via Roles 
Utilities, Loading Data 
Using The Loader 
Understanding The Loader Process 
Control File Options 
Direct Path Loads 

Utilities, Exporting & Importing Data 
Managing Indexes 
Indexes & Index Segments 
About B-Tree Indexes 
About Bitmap Indexes 
Index Definitions Within The Data Dictionary 

Managing Clusters & Indexed Organized Tables 

Globalization With National Language Support (NlS) 

Auditing Database Usage 
Auditing Users & Objects 
Specifying Auditing Actions

Oracle9i SQL (RT 262)
Oracle9i Advanced SQL (RT 258)
Oracle9i PL/SQL Language (RT 275)