OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » About PGA

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

About PGA [message #579949]

Mon, 18 March 2013 03:10

compuscience
Messages: 97
Registered: September 2012

Member

I need to ask about PGA memory
Is this memory for every user or every session

i.e PGA 200M
I have 2 users with 300 connection with one of them
Is 200M for 300 connection or for evey connect

Thank you very much

Report message to a moderator

Re: About PGA [message #579951 is a reply to message #579949]

Mon, 18 March 2013 03:23

John Watson
Messages: 8965
Registered: January 2010
Location: Global Village

Senior Member

Are you referring to this parameter,
http://docs.oracle.com/cd/E11882_01/server.112/e25513/initparams190.htm#CHDBJCDE
if so, that is the total value to which Oracle will attempt to restrict PGA, aggregated across all sessions.

Report message to a moderator

Re: About PGA [message #580448 is a reply to message #579951]

Sun, 24 March 2013 14:29

compuscience
Messages: 97
Registered: September 2012

Member

thank you

Report message to a moderator

Previous Topic:	regarding to required_mirror_free_mb
Next Topic:	About an error after login

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 23 00:53:51 CST 2025