Database Administration for Oracle 9i
Course No. OR9IDA 5 Days
► COURSE OVERVIEW ► COURSE OUTLINE
This class will cover Oracle9i and Oracle9i Release 2
features. Oracle DBAs manage the industries most MODULE 1: ORACLE ARCHITECTURAL
advanced information systems and command some of COMPONENTS
the highest salaries. This course is your first step
towards success as an Oracle professional, designed to
give you a firm foundation in basic database tasks. In Topics:
this class, you'll learn how to design, create, and Defining an Oracle Database, the Oracle server, and
maintain an Oracle database. Students will gain a the Oracle Instance
conceptual understanding of the Oracle database Establishing a connection and creating a session
architecture and how its components work and interact Understanding the physical structure
with one another. Students will also learn how to create Understanding the memory structure
an operational database and properly manage the
Understanding the process structure
various structures in an effective and efficient manner.
Understanding the logical structure
The lesson topics are reinforced with structured hands-
on practices. Outlining the stages of an SQL statement
► AUDIENCE MODULE 2: GETTING STARTED WITH THE ORACLE
Database Administrators SERVER
► OBJECTIVES
Topics:
Upon successful completion of this course, students
will be able to: Identifying database administrative tools
• Start up and shut down an Oracle instance and
database.
MODULE 3: IDENTIFYING THE FEATURES OF THE
UNIVERSAL INSTALLER
• Use Globalization Support features.
• Manage users, privileges, and resources. MODULE 4: DEFINING THE OPTIMAL FLEXIBLE
• Manage tablespaces, segments, extents, and blocks. ARCHITECTURE
• Manage Oracle database files.
• Create an operational database. MODULE 5: CREATING A DATABASE DURING
INSTALLATION
► PREREQUISITES MODULE 6: CREATING A NEW DATABASE
Before attending this course, students should have
taken the following course or have equivalent
knowledge:
• OR9I01 – Introduction to Oracle 9i
Database Administration for Oracle 9i
Course No. OR9IDA 5 Days
MODULE 7: IDENTIFYING DATABASE MODULE 12: MAINTAINING REDO LOG FILES
ADMINISTRATIVE USERS
Topics:
Topics: Explaining the purpose of and how online redo log files
Understanding operating system and password file work
authentication Control log switches and checkpoints
SQL*Plus Maintaining online redo log files
Enterprise Manager Managing online redo log files using OMF
Multiplexing and maintaining online redo log files
Archiving online redo log files
MODULE 8: MANAGING AN ORACLE INSTANCE Obtaining online and archived redo log file information
Topics: MODULE 13: MANAGING TABLESPACES AND
Creating, managing, and using initialization files: PFILE DATAFILES
and SPFILE
Identifying the various states of starting an instance
Identifying the various options available to shutdown MODULE 14: DESCRIBING STORAGE HIERARCHY
an instance
Monitoring Alert and Trace files MODULE 15: ESTABLISHING THE DIFFERENCE
BETWEEN SYSTEM AND NON-SYSTEM
MODULE 9: CREATING A DATABASE
TABLESPACES
Topics:
Using the Database Configuration Assistant to create a
Topics:
database Creating and managing tablespaces
Creating a database manually Creating a tablespace when using OMF
Obtaining tablespace and datafile information
MODULE 10: USING THE DATA DICTIONARY
Topics: MODULE 16: STORAGE STRUCTURES AND
Identifying the uses and contents of the data dictionary
Using the data dictionary to retrieve information about
RELATIONSHIPS
the database
Topics:
MODULE 11: MAINTAINING THE CONTROL FILE Describing the logical structure of the database
(segments, extents, blocks)
Listing the segment types and their uses
Topics:
Understanding the use of extents and their allocation
Explaining the uses of the control file and deallocation
Listing the contents of the control file Understanding the structure of a database block
Multiplexing the control file Maintaining storage structures with automatic segment
Managing control file with Oracle Managed Files (OMF) - space management
Obtaining control file information Maintaining storage structures manually
Obtaining storage structure information
Database Administration for Oracle 9i
Course No. OR9IDA 5 Days
MODULE 17: MANAGING UNDO DATA
MODULE 18: UNDERSTANDING THE DIFFERENCE
BETWEEN AUTOMATIC UNDO MANAGEMENT AND
MANUAL UNDO MANAGEMENT
MODULE 19: CREATING AND MAINTAINING UNDO
TABLESPACES
Topics:
Obtaining undo information
MODULE 20: MANAGING TABLES
Topics:
Creating and maintaining tables using appropriate
storage settings
Obtaining table information
MODULE 21: MANAGING INDEXES
Topics:
Listing the different types of indexes and their uses
Creating b-tree and bitmap indexes
Maintaining Indexes
MODULE 22: IDENTIFYING UNUSED INDEXES
Topics:
Obtaining index Information