Oracle Training : Oracle9i Database Administration

Oracle9i Database Administration - DBA I

Oracle Training Overview

This 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.

This course was formerly called �Oracle9i Database Architecture & Administration � DBA I�.

Oracle Training Prerequisites

The course Introduction To Oracle9i SQL
The course Introduction To Oracle9i PL/SQL Language
The course Introduction To Oracle9i Advanced SQL

Oracle Training Audience

Oracle database administrators

Oracle Training Objectives

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

Suggested Next Courses

The course Oracle 9i Database Backup & Recovery - DBA II
The course Oracle 9i Database Performance Tuning

Oracle Training Course duration

5 Days

Oracle Training Course outline

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 & USER PROCESSES

INSTANCE BACKGROUND PROCESSES
SQL EXECUTION PROCESSES

INSTALLATION & DATABASE CREATION

DATABASE ADMINISTRATOR AUTHENTICATION
PRE-INSTALLATION TASKS
POST-INSTALLATION TASKS

INSTANCE STARTUP & SHUTDOWN

DATABASE STARTUP
DATABASE SHUTDOWN
RESTRICTED SESSIONS
DATABASE FILES

DYNAMIC INSTANCE CONFIGURATION

DYNAMIC PARAMETER CHANGES
DETERMINING THE SCOPE OF CHANGES
VIEWING PARAMETER VALUES

USING LOCALLY-MANAGED TABLESPACES

ABOUT TABLESPACE MAINTENANCE
LOCALLY-MANAGED TABLESPACES
TEMPORARY SEGMENTS & 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 & IMPORTING DATA

MANAGING INDEXES

INDEXES & INDEX SEGMENTS
ABOUT B-TREE INDEXES
ABOUT BITMAP INDEXES
INDEX DEFINITIONS WITHIN THE DATA DICTIONARY

MANAGING CLUSTERS & INDEXED ORGANIZED TABLES

GLOBALIZATION WITH NATIONAL LANGUAGE SUPPORT (NLS)

AUDITING DATABASE USAGE

AUDITING USERS & OBJECTS

SPECIFYING AUDITING ACTIONS