And storage structures logical database

Database Architecture:
Summary of Structural Components

• Memory structures:
– System Global Area (SGA): Database buffer cache, redo buffer, and various pools
– Program Global Area (PGA)
• Process structures:
– User process and server process
– Background processes: SMON, PMON, DBWn, CKPT, LGWR, ARCn, and so on
• Storage structures:
– Logical: Database, schema, tablespace, segment, extent, and Oracle block
– Physical: Data files, control files, and redo log files

1 - 43

Summary

1 - 44