9I Dba Fundamentals I V 1

Oracle9i DBA Fundamentals I

Volume 1 • Student Guide

ly
n

O
e

al
n

r
O

cl
a

I
e

D11321GC10
Production 1.0
May 2001
D32643

er
nt

s
U

Authors

Copyright © Oracle Corporation, 2001. All rights reserved.

Sarath Chandran

This documentation contains proprietary information of Oracle Corporation. It is
provided under a license agreement containingrestrictions on use and disclosure
and is also protected by copyright law. Reverse engineering of the software is
prohibited. If this documentation is delivered to a U.S. Government Agency of the
Department of Defense, then it is delivered with Restricted Rights and the
following legend is applicable:

Marie St. Gelais
S Matt Taylor Jr

Restricted Rights Legend

Technical ReviewersUse, duplication or disclosure by the Government is subject to restrictions for
commercial computer software and shall be deemed to be Restricted Rights
software under Federal law, as set forth in subparagraph (c)(1)(ii) of DFARS
252.227-7013, Rights in Technical Data and Computer Software (October 1988).

Howard Bradley
Ruth Baylis
Paul Cartwright

This material or any portion of it may notbe copied in any form or by any means
without the express prior written permission of Oracle Corporation. Any other
copying is a violation of copyright law and may result in civil and/or criminal
penalties.

Trevor Davis
Joel Goodman
Scott Gossett

If this documentation is delivered to a U.S. Government Agency not within the
Department of Defense, then it is delivered with “RestrictedRights,” as defined in
FAR 52.227-14, Rights in Data-General, including Alternate III (June 1987).

Tomoki Ishii
Peter Kilpatrick

The information in this document is subject to change without notice. If you find
any problems in the documentation, please report them in writing to Education
Products, Oracle Corporation, 500 Oracle Parkway, Box SB-6, Redwood Shores,
CA 94065. OracleCorporation does not warrant that this document is error-free.

Stefan Lindblad
Howard Ostrow
Ashesh Parekh

SQL*Loader, SQL*Net, SQL*Plus, Net8, Oracle Call Interface, Oracle7, Oracle8,
Oracle 8i, Developer/2000, Developer/2000 Forms, Designer/2000, Oracle
Enterprise Manager, Oracle Parallel Server, PL/SQL, Pro*C, Pro*C/C++, and
Trusted Oracle are trademarks or registered trademarks of OracleCorporation.

Radhanes Petronilla
Venceslava Pretlova
Andreas Reinhardt

All other products or company names are used for identification purposes only,
and may be trademarks of their respective owners.

Ranbir Singh

ly
n

Peter Sharman
Barry Trute

O
e

Ric VanDyke
Karla Villasenor
John Watson

al
n

Teppei Yagihashi
Publisher

er
nt

Shane Mattimoe

r
O

cl
aI
e

s
U

Contents
Preface
Introduction
Course Objectives I-2
Oracle 9i Enterprise Edition I-3
Database Administrator Tasks I-4
1 Oracle Architectural Components
Objectives 1-2
Overview of Primary Componenets 1-3
Oracle Server 1-5
Oracle Instance 1-6
Establishing a Connection and Creating a Session 1-7
Oracle Database 1-9
Physical Structure 1-10
Memory Structure 1-11System Global Area (SGA) 1-12
Shared Pool 1-15
Library Cache 1-16
Data Dictionary Cache 1-17
Database Buffer Cache 1-18
Redo Log Buffer Cache 1-21
Large Pool 1-22
Java Pool 1-23
Program Global Area (PGA) 1-24
Process Structure 1-25
User Process 1-26
Sever Process 1-27
Background Processes 1-28
Database Writer (DBWn) 1-29
Log Writer (LGWR) 1-30
System Monitor (SMON) 1-31
Process Monitor(PMON) 1-32
Checkpoint (CKPT) 1-33
Archiver (ARCn) 1-35
Logical Structure 1-37
Processing a SQL Statement 1-38
Summary 1-40
Practice 1 Overview 1-41

al
n

I
e

cl
a

2

r
O

er
nt

Getting Started With the Oracle Server
Objectives 2-2
Database Administration Tools 2-3

iii

s
U

O
e

ly
n

Oracle Universal Installer 2-4
Interactive Installation 2-5...