| |
GeekInterview.com > Interview Questions > Oracle > System Architecture
| Print | |
| Question: What are the components of SGA ?
Answer: Database buffers, Redo Log Buffer the Shared Pool and Cursors. |
| March 03, 2005 00:38:24 |
#1 |
| nishit patel |
Member Since: Visitor Total Comments: N/A |
RE: What are the components of SGA ?
|
| 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 |
| |
Back To Question | |
