OraFAQ Forum: Server Administration » Private SQL Area and Shared SQL Area

Home » RDBMS Server » Server Administration » Private SQL Area and Shared SQL Area

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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

Report message to a moderator

Previous Topic:	DBA task levels
Next Topic:	Data accessed from Undo Segment OR Buffer Cache

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 07:26:57 CDT 2024