Oracle memory allocation-memory allocation (SGA and PGA) structure of SGA and PGA

SGA is the memory area used to store database information, which is shared by database processes. It contains data and control information of the Oracle server.

SGA is the memory area used to store database information, which is shared by database processes. It contains data and control information of the Oracle server.

SGA is the memory area used to store database information, which is shared by database processes. It contains data and control information of the Oracle server. It is allocated in the actual memory of the computer where the Oracle server resides. If the actual memory is insufficient, it is written into the virtual memory.

PGA: contains the data and control information of a single server process or a single background process. The SGA shared with several processes is the opposite. PGA is only used by one process, PGA is allocated during Process Creation and recycled upon Process Termination.

Memory Allocation (SGA and PGA)