OraFAQ Forum: Performance Tuning » where is UGA stored ??

Home » RDBMS Server » Performance Tuning » where is UGA stored ??

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

where is UGA stored ?? [message #164527]

Thu, 23 March 2006 20:37

tridentadm
Messages: 142
Registered: March 2006

Senior Member

where is the UGA information stored if I am having PGA along with Large Pool configured, in a Non-Shared-Server configuration ????

Report message to a moderator

Re: where is UGA stored ?? [message #164615 is a reply to message #164527]

Fri, 24 March 2006 06:02

amit_nanote
Messages: 56
Registered: July 2005
Location: Indore

Member

HI tridentadm,

I have gone through your query and find out that in case of Shared server connection better to configure the large Pool.

Here You are having PGA with Large Pool Configured.
This PGA also have a UGA which send the request to SHARED POOL which treats the request per user basis.

Dedicated server Configuration of SGA and PGA -
SGA - Shared Pool and other memory structures
PGA -
1. User Session
2. Stack Space
3. Cursor state

Shared Server Configuration of SGA and PGA
SGA - Shared Pool have the User session and the Cursor state in case of Large pool is not configured
PGA - Stack Space only

Further Quries are invited.

Regds
Amit

Report message to a moderator

Previous Topic:	Merge-Update vs Normal Update
Next Topic:	help!!->resolving "cpu time" problem

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Nov 27 08:37:54 CST 2024