System Architecture - What are the components of SGA ?

GeekInterview.com > Interview Questions > Oracle > System Architecture

Go To First | Previous Question | Next Question

System Architecture | Question 3 of 33

What are the components of SGA ?

Database buffers, Redo Log Buffer the Shared Pool and Cursors.

Total Answers and Comments: 10

Last Update: July 02, 2009

Sponsored Links

Best Rated Answer

—

Submitted by: nishit patel

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

Above answer was rated as good by the following members:
rnraomaddula

March 12, 2005 00:38:24

nishit patel

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

Is this answer useful? Yes | No

1 0

Overall Rating: +1

October 11, 2005 10:30:39

nishant

RE: What are the components of SGA ?

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

Is this answer useful? Yes | No

January 09, 2006 17:21:20

Merter Savaseri

RE: What are the components of SGA ?

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

Is this answer useful? Yes | No

April 09, 2006 10:12:16

balaji

RE: What are the components of SGA ?

yes library cache and dictionary cache are part of SGA

Is this answer useful? Yes | No

May 17, 2006 02:29:08

sampath kumar

RE: What are the components of SGA ?

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.

Is this answer useful? Yes | No

August 25, 2006 14:14:46

nisha

RE: What are the components of SGA ?

components of sga are:-

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

Is this answer useful? Yes | No

January 30, 2007 18:50:59

nitanjandial

Member Since: December 2006 Contribution: 4

RE: What are the components of SGA ?

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

Is this answer useful? Yes | No

March 09, 2007 05:18:14

raja.aggarwal

Member Since: April 2006 Contribution: 1

RE: What are the components of SGA ?

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

Is this answer useful? Yes | No

October 06, 2008 04:41:48

sankar21

Member Since: October 2008 Contribution: 2

RE: What are the components of SGA ?

Shared pool data buffer cache redo log buffer.