Home » RDBMS Server » Server Administration » Private SQL Area and Shared SQL Area
Private SQL Area and Shared SQL Area [message #260542] Mon, 20 August 2007 04:52
naveenkumar001
Messages: 62
Registered: July 2007
Location: Bangalore
Member

Hi,

I searched a lot about Private SQL Area and Shared SQL Area in net and i got information about them in net also but i was not able to understand it. Please help me.

1) For Shared Server the Private SQL Area is moved to SGA since Library Cache contains Shared SQL Area which contains most recently executed SQL statements, then whats the use of Private SQL Area?

2) Also for Dedicated Server the Private SQL Area is in PGA since Library Cache contains Shared SQL Area which contains most recently executed SQL statements, then whats the use of Private SQL Area?

3) Also i am not getting the difference between Shared SQL Area and Private SQL Area, why we need both and whats the use of them?


Regards,
Naveen
Previous Topic: DBA task levels
Next Topic: Data accessed from Undo Segment OR Buffer Cache
Goto Forum:
  


Current Time: Thu Dec 08 20:27:47 CST 2016

Total time taken to generate the page: 0.11616 seconds