nishit patel

• Mar 12th, 2005

 

SGA * stands for System/Shared Global Area* can be used/shared by all users* it is a part of memory structure of Instance* consists of memory components like 1> shared pool 2> Database cache 3> log buffer 4> large pool 5> java poolInstance * is a mens to access a database* part of Oracle serverOracle server* consists of Instance & Databse.Thank U,By NISHIT PATEL.mail: nishitptl@yahoo.co.in

Ravi Prakash Pichika

• Jun 5th, 2005

 

SGA - Stands for System Global Area, its a part of Memory structure! SGA consists of  
 
Shared Pool 
Database Buffer Cache 
Redo Log Buffer 
Lock & Latch Management 
 
& More Aditional Memory Structures 
 
Large pool & Java Pool 
 
another name of SGA is Shared Global Area. It is used to store database information that is shared by database processes. It contains Data and control information for the Oracle Server and is allocated in the Virtual Memory of the computer - where Oracle Resides. 
 
Thanks & Plz free to contact me on raviprakash.dba@gmail.com