Database 9i: Administration (DBA): Level 1

Scheduled Dates (sort by: location | date)

Course Overview

This DBA course is intended for those who are responsible for managing, maintaining and supporting Oracle version 9i.

Extensive exercises start on day one where delegates use the command line to create an Oracle 9i database. This database is then used throughout the week. Delegates will load and monitor database performance using sample data. Examples are used to show the effects of system loading and user interaction.

Prerequisites

We suggest completion of our SQL*Plus Fundamentals course (or equivalent experience). PL/SQL knowledge is also an advantage.

Course Outline

ORACLE ARCHITECTURAL COMPONENTS:

• Defining an Oracle server, the Oracle instance, and the Oracle database
• understanding the physical structure
• understanding the memory structure
• understanding the process structure
• understanding the logical structure
• establishing a connection and creating a session
• processing a SQL statement.

GETTING STARTED WITH THE ORACLE SERVER:

• Features of the universal installer
• optimal flexible architecture
• creating a database
• identifying database administrative users
• understanding operating system and password file authentication

MANAGING AN ORACLE INSTANCE:

• Managing PFILE and SPFILE initialisation files
• identifying the states of starting an instance
• options to shutdown an instance
• obtain and set parameter values
• monitoring alert and trace files

CREATING A DATABASE:

• Using database configuration assistant to create a database
• creating a database!

DATA DICTIONARY VIEWS CONTENTS AND USAGE:

• Identifying the uses and contents of the data dictionary
• using the data dictionary to obtain information!

MAINTAINING THE CONTROL FILE:

• Explaining the use of the control file
• contents of the control file
• multiplexing the control file
• managing control file with OMF
• obtaining control file information

MAINTAINING REDO LOG FILES:

• Use of online redo log files
• structure of redo log files
• controlling log switches and checkpoints
• managing online redo log files
• managing online redo log files using OMF
• multiplexing online redo log files
• obtaining online redo log file information

MANAGING TABLESPACES AND DATA FILES:

• The logical structure of the database
• types of table spaces
• creating tablespaces
• changing the size of tablespaces
• allocating space for temporary segments
• changing the status of tablespaces
• changing the storage settings of tablespaces
• relocating tablespaces

STORAGE STRUCTURE AND RELATIONSHIPS:

• Segment types
• storage clause precedence
• extents and their purpose
• data block structure

MANAGING UNDO DATA:

• Purpose of undo data
• types of undo segments
• automatic undo management concepts and configuration
• creating and maintaining undo tablespaces

MANAGING TABLES:

• Oracle data types
• ROWID formats
• structure of a row
• creating tables

MANAGING INDEXES:

• Different types of indexes
• creating B*-Tree and bitmap indexes
• reorganising indexes

MAINTAINING DATA INTEGRITY:

• Implementing data integrity
• maintaining integrity constraints
• obtaining constraint information from the data dictionary

MANAGING PASSWORD SECURITY AND RESOURCES:

• Managing passwords using profiles
• administering profiles!

MANAGING USERS:

• Creating new database users
• altering and dropping existing database users
• monitoring information

MANAGING PRIVILEGES:

• Identifying system and object privileges
• granting and revoking privileges
• controlling operating system or password file authentication
• identifying auditing capabilities

MANAGING ROLES:

• Creating and modifying roles
• controlling availability of roles
• removing roles
• using predefined roles

USING NATIONAL LANGUAGE SUPPORT:

• Database character sets and national character sets
• using globalisation support parameters
• obtaining globalisation support information

Database 9i: Administration (DBA): Level 1 / ORD9i-A1