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