Oracle Architecture

Databases and Instances

Pluggable Databases

DB_NAME

Deployin Physical Components

Redo Logfiles

Instance Memory and Processes

Memory Structures for an Instance

Background Processes for an Instance

Configuration, Engineered Systems, and the Cloud

Oracle Database Structures

Files of a database

Implementation

PBDs and Oracle features

Databse Initialization

CONTROL FILES

MEMORY TARGET

Datafiles

Datafile Structure

Extents and segments

Multiplexing redo logfiles

Naming conventions for redo logs

Archived redo logs

ARCHIVELOG mode and automatic archiving

Database buffer cache

DEFAULT

KEEP

KEEP

Shared pool

Redo log buffer

Other pools in the SGA

Java pool

Streams pool

Automatic PGA management

Database Writer (DBWn)

Log Writer (LGWR)

System Monitor (SMON)

Process Monitor (PMON)

Archiver (ARCn)

Checkpoint (CKPT)

Recover (RECO)

Dispatcher

Global Cache Service (LMS)

Job Queue

Queue Monitor (QMNn)

Automatic Storage Management (ASM) processes

Tablespaces

Schemas

Control Files

click to edit

Data Dictionary