Lesson One - Oracle Architectural Components

08/15/1999


Click here to start


Table of Contents

PPT Slide

Objectives

The Oracle Server

Connecting to a Database

User Process

Server Process

Oracle Instance

Oracle Database

Other Key Physical Structures

Processing a Query

The Shared Pool

Database Buffer Cache

Program Global Area (PGA)

Processing a DML Statement

Rollback Segment

Redo Log Buffer

Database Writer (DBWR)

Log Writer (LGWR)

COMMIT Processing

Summary

Author: Oracle

Email: melody@ecst.csuchico.edu

Home Page: http://www.ecst.csuchico.edu/~melody

Download presentation source