Home » RDBMS Server » Server Administration » About PGA
About PGA [message #579949] Mon, 18 March 2013 03:10 Go to next message
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
Re: About PGA [message #579951 is a reply to message #579949] Mon, 18 March 2013 03:23 Go to previous messageGo to next message
John Watson
Messages: 8922
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.
Re: About PGA [message #580448 is a reply to message #579951] Sun, 24 March 2013 14:29 Go to previous message
compuscience
Messages: 97
Registered: September 2012
Member
thank you
Previous Topic: regarding to required_mirror_free_mb
Next Topic: About an error after login
Goto Forum:
  


Current Time: Thu Mar 28 12:58:32 CDT 2024