nishit patel

• Mar 12th, 2005

 

Components of SGA are :1> Shared pool : consists of shared sql area and shared pl/sql area2> Data Base buffer cache(DB cache) : contains most recently used blocks & dirty blocks(modified but not yet written to datafile)3> Redolog Buffer : contains changed/redo data4> Large pool : used only in parellel sever environment5> Java pool : used when you are using java strored procedures etc.Thank U,By NISHIT PATEL.mail : nishitptl@yahoo.co.in

nishant

• Oct 11th, 2005

 

Hi,

Can u tell me whether Library cache and datadictionary cache are part of SGA????plz reply..It was an interview question asked in Oracle corporation

Merter Savaseri

• Jan 9th, 2006

 

They are the part of shared pool and shared pool is a part of SGA.

balaji

• Apr 9th, 2006

 

yes , library cache and dictionary cache are part of SGA

sampath kumar

• May 17th, 2006

 

inside the sharepool,library cache,data dictionary cache is present. library cache-it store most reciently used sql and plsql commands.. data dictionary cache- it store information table,view,user privilage,segment,tablespace.

nisha

• Aug 25th, 2006

 

components of sga are:-

data buffer cache,datadictionary cache,redo log buffer,shared pool area.

nitanjandial

 Profile Answers by nitanjandial 

• Jan 30th, 2007

 

Yes,they(Library and data dictionary cache)are come under shared poolshared pool come under SGAthat's mean they are the part of SGAthanks,Nitan Jandial

raja.aggarwal

 Profile Answers by raja.aggarwal 

• Mar 9th, 2007

 

Its a part of shared pool and both comes under sga by default

sankar21

 Profile Answers by sankar21 

• Oct 6th, 2008

 

Shared pool, data buffer cache, redo log buffer.

saihaan

 Profile Answers by saihaan 

• Jul 2nd, 2009

 

Yes. they are part of SGA. Sharedpool comprises of Library cache and data dictionary cache.

Nagaraj OCP

• Dec 27th, 2011

 

SGA has six parts on it

Shared pool
JAVA POOL
Stream Pool
Large Pool
Data Buffer cache - MRU, LRU
Redo log buffer