Oracle 9i DBA I

Request more details:

Description:
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.

View other Oracle Courses available
Prerequisites:
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
DBA Responsibilities
Tables, Constraints and Indexes:
Introduction to Datatypes and Tables
Integrity Constraints
Temporary tables, partitioned tables (range, hash, list), external tables, IOTs
Indexes and Skip Scanning
Online reorganisation
Database workspace management
Other Database Schema Objects:
DDL Commands used
Views, Materialised views
Sequences, Synonyms, Database Links
Outlines, Dimensions, Hierarchies
PL/SQL Program Units
Supplied Packages
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:
Basic Definitions
Blocks & Extents
Fragmentation / Deallocation
How Space is Logically Consumed - Segments:
Introduction to Segments
Managing Undo Segments
Automatic Undo Management
Managing sort activity, and Data and Index Segments
Monitoring database segments
Managing Tablespaces - Default behavior of CREATE TABLESPACE command:
Tablespace Overview
System Tablespace
Types of Tablespaces
Creating additional tablespaces
Altering tablespaces
Temporary Tablespaces
Tablespace Quotas
Monitoring Tablespaces
Basic Oracle Architecture:
Architecture Overview
Database and Process structures
Memory structures - SGA, PGA
Alternative configurations
Oracle Database Files:
Basic Structures of an Oracle RDBMS
Data Files, Redo Log Files
Archived Redo Log Files
Control Files, Oracle-Managed Files (OMF)
Users and Security:
Managing Database Users
System and Object Privilages
Managing Roles, Profiles and Passwords
Resource Manager
The Virtual Private Database
Oracle DBA Tools:
OEM Configuration and Console
Oracle Management Server Configuration, and Other OEM Console Tools
Apache Server
ORADIM
Universal Installer
Creating an Oracle Database:
Benefits of OFA
Planning a database
Creating a Database
The CREATE DATABASE Command
Using the Database Configuration Assistant
Oracle Auditing:
Types of Auditing
Establishing an audit trail repository
Auditing options, Audit results
PL/SQL Packages for the DBA:
DBMS_DDL
DBMS_JOB
DBMS_PCLXUTIL
DBMS_RESOURCE_MANAGER
DBMS_ROWID
DBMS_SESSION
DBMS_SHARED_POOL
DBMS_SPACE
DBMS_SPACE_ADMIN
DBMS_TTS
DBMS_UTILITY
Globalization Support:
Character sets supported
Choosing a character set
Multi-byte character sets
National Language Support (NLS)
Defining time zones
A Day in the life of a DBA:
Daily, Weekly, Monthly, and As Needed Tasks