Tell me what are the components of SGA?
Submitted by: AdministratorComponents 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.
Submitted by: Administrator
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.
Submitted by: Administrator
Read Online Oracle System Architecture Job Interview Questions And Answers
Top Oracle System Architecture Questions
| ☺ | Explain what are functions of PMON? |
| ☺ | What is the function of Lock (LCKn) Process in System Architecture? |
| ☺ | Tell me what are the functions of SMON? |
| ☺ | Explain what are the different Oracle Kernel Layers? |
| ☺ | Explain what do Redo Log Buffers contain? |
Top DB Oracle Categories
| ☺ | Oracle PL-SQL Interview Questions. |
| ☺ | Oracle DBA Interview Questions. |
| ☺ | Oracle D2K Interview Questions. |
| ☺ | OCI Interview Questions. |
| ☺ | Oracle RMAN Interview Questions. |
