GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

  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.


May 05, 2006 02:29:08 #5
 sampath kumar   Member Since: Visitor    Total Comments: N/A 

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.
     

 

Back To Question