1

Oracle Architectural Components

2

Getting started with the Oracle Server

3

Identifying the features of the Universal Installer

4

Defining the Optimal Flexible Architecture

5

Creating a database during installation

6

Creating new database

7

Identifying database administrative users

8

Managing an oracle instance

9

Creating database

10

Using data dictionary

11

Maintaining the control file

12

Maintaining Redo Log file

13

Managing tablespace and datafiles

14

Describing storage hierarchy

15

Establishing the difference between System and Non-System Tablespaces

16

Storage Structures and Relationship

17

Understanding the difference between automatic undo management and manual undo

18

Creating and maintaining UNDO Tablespaces

19

Managing Table

20

Managing Indexes

21

Identifying unused indexes

1

Networking Overview

2

Basic Oracle Net Architecture

3

Basic Oracle Net Services Server-Side Configuration

4

Basic Oracle Net Services Client-Side Configuration

5

Usage and Configuration of the Oracle Shared Server

6

Backup and recovery overview

7

Instance and media recovery structures

8

Configuration of the database archiving mode

9

Oracle recovery manager(RMAN)overview and configuration

10

User-managed backups

11

RMAN Backups

12

User-managed complete recovery

13

RMAN incomplete recovery

14

RMAN Repository Maintenance

15

RMAN Catalog creation and usage

16

Transporting data between databases

1

Overview of Oracle 9i Performance Tuning

2

Diagnostic and Tuning Tools

3

Sizing the shared pool

4

Sizing the buffer cache

5

Sizing other SGA structure

6

Database configuration and I/O Issues

7

Optimize Sort Operations

8

Diagnosing contention For Latches

9

Tuning Rollback or undo segments

10

Monitoring and detecting lock contention

11

Tuning Oracle shared server

12

Application Tuning

13

Using Oracle blocks efficiently

14

SQL Statement Tuning

15

Tuning the operating system and suing resource manager