Oracle9i Database Administration (DBA I)

This 5-day course provides a starting point for administration of the Oracle database. The first 2-day segment considers an in-depth discussion of the database architecture, including the Oracle instance, background processes, the SGA and memory structures, data files, tablespaces, extents, blocks and rows. Common administration tasks are also considered such as security, backup & recovery, physical storage of indexes and tables and many others.
On course completion, students will be able to:

• Install, startup and shutdown an Oracle database
• Explain the internal architecture of data, memory and process structures
• Administer a security policy for the database
• Configure a basic backup & recovery strategy
• Control physical storage of tables and indexes
• Build efficient databases with clusters and bitmap indexes

Target audience

This course has been developed for Oracle database administrators. Students are recommended to have attended the following course or have the equivalent knowledge and experience:

• Introduction To Oracle9i SQL
• Introduction To Oracle9i PL/SQL Language
• Introduction To Oracle9i Advanced SQL

Course content

The Oracle database environment Application architectures • The Oracle database • Components of a database • Instance configurations • About the administration tools

Memory structures within the instance Parameters which determine sga size

Instance and user processes Instance background processes • SQL execution processes

Installation and database creation Database administrator authentication • Pre-installation tasks • Post-installation tasks

Instance start-up and shut-down Database start-up • Database shut-down • Restricted sessions • Database files

Dynamic instance configuration Dynamic parameter changes • Determing the scope of changes • Viewing parameter changes

Using locally-managed tablespaces About tablespace maintenance • Locally-managed tablespaces • Temporary segments and tablespaces • The optimal flexible architecture

Using dictionary-managed tablespaces Dictionary-managed tablespaces • Migrating the tablespace management method

Managing data files The storage hierarchy • Exploring the physical storage hierarchy • Managing the data files

Managing redo logs

Automatic undo space management Configuring automatic undo space management • Tuning automatic undo space management

Implementing Oracle managed files

Managing users User management • About privileges • Resource limits via profiles • Password management via profiles

Managing privileges via roles

Utilities, loading data Using the loader • Understanding the loader process • Control file options • Direct path loads

Utilities, exporting and importing data

Managing indexes Indexes and index segments • About B-tree indexes • About bitmap indexes • Index definitions within the data directory

Managing clusters and indexed organized tables

Globalization with national language support (NLS)

Auditing database usage Auditing users and objects

Specifying auditing actions

About Courseware Company :: Instructor-led training courseware :: Self-study solutions :: Buy online today