Oracle System Architecture Question:
Download Job Interview Questions and Answers PDF
Tell me what are the components of SGA?
Answer:
Components of SGA are :
1> Shared pool : consists of shared sql area and shared pl/sql area
2> 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 data
4> Large pool : used only in parellel sever environment
5> Java pool : used when you are using java strored procedures etc.
1> Shared pool : consists of shared sql area and shared pl/sql area
2> 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 data
4> Large pool : used only in parellel sever environment
5> Java pool : used when you are using java strored procedures etc.
Download System Architecture Interview Questions And Answers
PDF
| Previous Question | Next Question |
| Why is Oracle called kernel package? | What is a cluster and how it is used? |