What are memory structures in Oracle?

Showing Answers 1 - 1 of 1 Answers

IRINA

  • Apr 9th, 2005
 

The basic memory structures associated with Oracle include:  
? System Global Area (SGA), which is shared by all server and background  
processes and holds the following:  
o Database buffer cache  
o Redo log buffer  
o Shared pool  
o Large pool (if configured)  
? Program Global Areas (PGA), which is private to each server and background  
process; there is one PGA for each process. The PGA holds the following:  
o Stack areas  
o Data areas

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions