Raj Info Enterprise Oracle Database Administrator Interview Questions and Answers

Oracle architecture is a multi-layered design that includes physical, memory, and process components.

• Oracle architecture consists of physical, memory, and process components.

• The physical component includes data files, control files, and redo log files.

• The memory component includes the System Global Area (SGA) and Program Global Area (PGA).

• The process component includes background processes and user processes.

• Oracle arc...read more

Background processes are essential components of Oracle database that run continuously in the background. Memory architecture is the way Oracle manages memory.

• Background processes include DBWn, LGWR, PMON, SMON, etc.

• Memory architecture includes SGA, PGA, buffer cache, shared pool, etc.

• SGA is a shared memory region that stores data and control information.

• PGA is a private memory region that stores session-specific infor...read more