Course Overview

This course is designed to give the Oracle database administrator (DBA) a firm foundation in basic database administrative tasks. Students gain a thorough conceptual understanding of the Oracle database architecture, and how the architectural structures of an Oracle9i database work and interact with one another. Students also learn how to create an operationalThis course is designed to give the Oracle database administrator (DBA) a firm foundation in basic database administrative tasks. Students will gain a conceptual understanding of the Oracle9i database architecture and how the architectural structures work and interact with one another. Students will also learn how to create an operational database and properly manage the various structures in an effective and efficient manner in order to have a well-designed and operational database. In addition to learning the various commands needed to perform the DBA tasks, the course also provides students with instruction to perform the same DBA tasks using the Oracle Enterprise Manager tool. The instructor-led lesson topics are reinforced with structured hands-on practices.

Oracle Architectural Components

• Understanding the physical structure
• Understanding the memory structure
• Understanding the process structure
• Understanding the logical structure
• Outlining the stages of an SQL statement
• Defining an Oracle Database, the Oracle server, and the Oracle Instance
• Establishing a connection and creating a session

Getting Started with the Oracle Server

• Identifying database administrative tools

Identifying the features of the Universal Installer

Defining the Optimal Flexible Architecture

Creating a database during installation

Creating a new database

Identifying database administrative users

• Understanding operating system and password file authentication
• SQL*Plus
• Enterprise Manager

Managing an Oracle Instance

• Creating, managing, and using initialization files: PFILE and SPFILE
• Identifying the various states of starting an instance
• Identifying the various options available to shutdown an instance
• Monitoring Alert and Trace files

Creating a Database

• Using the Database Configuration Assistant to create a database
• Creating a database manually
•  

Using the Data Dictionary

• Identifying the uses and contents of the data dictionary
• Using the data dictionary to retrieve information about the database

Maintaining the Control File

• Explaining the uses of the control file
• Listing the contents of the control file
• Multiplexing the control file
• Managing control file with Oracle Managed Files (OMF)
• Obtaining control file information

Maintaining Redo Log Files

• Explaining the purpose of and how online redo log files work
• Control log switches and checkpoints
• Maintaining online redo log files
• Managing online redo log files using OMF
• Multiplexing and maintaining online redo log files
• Archiving online redo log files
• Obtaining online and archived redo log file information

Managing Tablespaces and Datafiles

Describing storage hierarchy

Establishing the difference between SYSTEM and Non-SYSTEM tablespaces

• Creating and managing tablespaces
• Creating a tablespace when using OMF
• Obtaining tablespace and datafile information

Storage Structures and Relationships

• Describing the logical structure of the database (segments, extents, blocks)
• Listing the segment types and their uses
• Understanding the use of extents and their allocation and deallocation
• Understanding the structure of a database block
• Maintaining storage structures with automatic segment - space management
• Maintaining storage structures manually
• Obtaining storage structure information

Managing Undo Data

• Understanding the difference between automatic undo management and manual undo management
• Creating and maintaining UNDO tablespaces
• Obtaining undo information

Managing Tables

• Creating and maintaining tables using appropriate storage settings
• Obtaining table information

Managing Indexes

• Listing the different types of indexes and their uses
• Creating b-tree and bitmap indexes
• Maintaining Indexes
• Identifying unused indexes
• Obtaining index Information

Maintaining Data Integrity

• Implementing data integrity constraints
• Maintaining integrity constraints
• Obtaining constraint information

Managing Password Security and Resources

• Managing passwords using profiles
• Administering profiles
• Controlling use of resources using profiles
• Managing resources using the Database Resource Manager
• Obtaining information about profiles, password management, and resources

Managing Users

• Creating new database users
• Altering and dropping existing database users
• Obtaining user information

Duration:- 6 month