Oracle Architecture

Oracle database:
1.Physical database:
----i.Data file
----ii.Redo log file
----iii.Control file
2.Instance:
---- i.Large memory area:
-------- a. System Global Area (SGA):
-------------------- 1. Database buffer cache
-------------------- 2. Redo log buffer
-------------------- 3. Shared pool
-------------------- 4. Java pool
-------------------- 5. Large pool (optional)
-------------------- 6. Streams pool
-------------------- 7. Dictionary cache:
---------------------------- Data Dictionary cache
---------------------------- Library cache
-------------------- 8. Other miscellaneous information
-------- b. Program Global Area (PGA)
-------- c. Optional Area – Software Area Code
---- ii.Set of background processes:
-------- a. Database Writer Process (DBWn)
-------- b. Log Writer Process (LGWR)
-------- c. Checkpoint Process (CKPT)
-------- d. System Monitor Process (SMON)
-------- e. Process Monitor Process (PMON)
-------- f. Recoverer Process (RECO)
-------- g. Job Queue Processes
-------- h. Archiver Processes (ARCn)
-------- i. Queue Monitor Processes (QMNn)
-------- j. Other Background Processes