Oracle 10g Database Administration I (OCA)

Duration: 5 days

Audience: Oracle database administrators.

Prerequisites: Oracle 10g SQL

Course Contents:

Installing Oracle 10g database software

Exploring the Oracle database architecture

Database instance process architecture

Creating an Oracle database

Controlling the database environment

Storage structures: tablespaces

Storage structures: advanced tablespaces

Storage structures: data files & temp file

Undo Management

Database security

Administering users

Loading data with SQL*Loader

Exporting & importing data

Oracle net services

Oracle shared server (Multithreaded server)

Monitoring and resolving lock conflicts

Backup and recovery concepts