Audience:

·         Database Administrators

Course Objectives:

·         Manage tablespaces, segments, extents, and blocks

·         Manage users, privileges, and resources

·         Create an operational database

·         Start up and shut down an Oracle instance and database

·         Manage Oracle database files

·         Use Globalization Support features

Course Topics:

Oracle Architectural Components

·         Defining an Oracle Database, the Oracle server, and the Oracle Instance

·         Establishing a connection and creating a session

·         Understanding the physical structure

·         Understanding the memory structure

·         Understanding the process structure

·         Understanding the logical structure

·         Outlining the stages of an SQL statement

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