Classes :: class description :

Oracle 8 DBA

Overview

The complexity and flexibility of the Oracle database make the task of administration of Oracle databases appears somewhat intimidating. This course concentrates on the basics and the practical: how to install an Oracle database, what are the decision points during installation, and what are the initial tasks needed to have a fully operational database ready for use. Logical and physical attributes are discussed as well as the processes and structures needed to control the database. Basic database tuning is also covered. Practical exercises are designed to complement the classroom lectures. Examples in the class are based on UNIX and/or Windows NT. However, it is primarily OS non-specific.

Prerequisites

Students must be familiar with System and Basic Engineer.

Ourline

MODEL 1:  (Oracle DBA) 

·        Roles and Responsibilities

·        Developer DBA vs. Production DBA

·        Resources for Learning

·        Internet resource

·        Books, magazines, videos, CBT, etc.

·        Oracle Certified Professional Program

·        Basic Schema Objects

·        Table, datatypes

·         Integrity rules

MODEL 2:  (Oracle DBA) 

·        Basic Scheme Objects

·        View, sequence, synonym, index, stored program units

·        The Oracle Database

·        Static Data Dictionary

·        Dynamic Data Dictionary

·        Key queries with the data dictionary

MODEL 3:  (Oracle DBA) 

·        Logical Object Storage

·        Block definition and management

·         Extent management

MODEL 4:  (Oracle DBA) 

·        Logical Object Storage

·        Segments (temporary, sort, rollback)

·         Table space management

MODEL 5:  (Oracle DBA) 

·        Physical Database Architecture

·        Database vs. Instance

·        Datafile management

·        Adding Datafiles

·        Datafile auto-extension

·         Resizing datafiles

MODEL 6:  (Oracle DBA) 

·        Controlfile management

·        Redo log file management

·        Bypassing writes to the redo logs

·         Recoverable vs. unrecoverable

MODEL 7:  (Oracle DBA) 

·        Physical Database Architecture

·        Memory management

·         Process Architecture

MODEL 8:  (Oracle DBA) 

·        Startup and shutdown options

·        Basic Oracle Database Installation

·        Pre-installation issues

·         Init.ora

MODEL 9:  (Backup and Recovery) 

·        Basic Backup Concepts

·        Noarchivelog backups options

·        Archivelog backups

·         Cold Backups

·        Hot Backups

·        Archivelog Management

·        Physical vs. Logical Backups

·        Import/Export

·        Issues with large database exports/Imports.

·        DB verify utility

·         Recovery Concepts

MODEL 10:  (Backup and Recovery) 

·        Basic Recovery Concepts

·        Recovery for Archivelog mode database

·        Complete Recovery

·         Incomplete Recovery

MODEL 11:  (Oracle DBA) 

·        Security

·        User’s Management

·        Privileges

·        Profiles

·        Password Management

·        Roles

·         Auditing

MODEL 12:  (Performance Tuning) 

·        Concurrence Management in Oracle

·        Locks

·        Tuning an Oracle Database

·        Role in Database and application design

·        Oracle SQL Optimization

·        Rule-base Optimizer

·        Cost-base Optimizer

·        Use of Hint

·         Steps in Tuning

MODEL 13:  (Performance Tuning)

·        Tuning an Oracle Database

·        Tuning Memory

·        Tuning I/O

·        Tuning CPU

·         Other Tuning issues

MODEL 14:  (Oracle DBA) 

·         Indexes

MODEL 15:  (Oracle DBA) 

·        Partition Option

·         Other Database Options

MODEL 16:  (Oracle DBA) 

·        Using Oracle Enterprise Manager (OEM) to manage your database

·        Installing and configuring 0EM

·        OEM Tools

·         Additional Optional OEM Tools

MODEL 17:  (Backup and Recovery) 

·        Backup and Recovery using Recovery manager

·        RMAN Concepts and Capabilities

·        Installation and Connection of RMA

·        Backup using RMAN

·         Recovery using RMAN

MODEL 18:  (Network Administration) 

·        Oracle and the Network

·        Net8

·        Oracle Replication

·         Snapshots

MODEL 19:  (Oracle DBA)

             ·         Loading Data into Oracle

MODEL 20:  (Oracle DBA) 

·        3rd Party tools to help you do your job

·         Final Review