Home » RDBMS Server » Performance Tuning » What does "session uga memory"/"session uga memory max" signifies and how to interpret the value def (general)
What does "session uga memory"/"session uga memory max" signifies and how to interpret the value def [message #610169] Tue, 18 March 2014 05:21 Go to next message
Kevin Meade
Messages: 2103
Registered: December 1999
Location: Connecticut USA
Senior Member
Hi,

What does "session uga memory"/"session uga memory max" signifies and how to interpret the value defined for it in AWR report?

Below is a section of AWR report -

Statistic
Begin Value
End Value

session pga memory max
157,844,074,168
162,254,322,536

session cursor cache count
9,230,278
9,237,092

session uga memory
172,057,890,192,200
172,125,260,522,584

opened cursors current
113
284

workarea memory allocated
995
2,049

logons current
86
101

session uga memory max
1,583,703,321,096
1,589,232,535,352

session pga memory
139,310,459,256
142,984,590,216



Thanks

Mainak Ghosh
Re: What does "session uga memory"/"session uga memory max" signifies and how to interpret the value def [message #610170 is a reply to message #610169] Tue, 18 March 2014 05:26 Go to previous messageGo to next message
cookiemonster
Messages: 13894
Registered: September 2008
Location: Rainy Manchester
Senior Member
How are you logged in as Kevin Meade?
Re: What does "session uga memory"/"session uga memory max" signifies and how to interpret the value def [message #610172 is a reply to message #610170] Tue, 18 March 2014 05:37 Go to previous messageGo to next message
Kevin Meade
Messages: 2103
Registered: December 1999
Location: Connecticut USA
Senior Member
Yes, I would like to know that too.

Especially since I have recently updated my password.

Kevin

[Updated on: Tue, 18 March 2014 05:38]

Report message to a moderator

Re: What does "session uga memory"/"session uga memory max" signifies and how to interpret the value def [message #610176 is a reply to message #610172] Tue, 18 March 2014 05:49 Go to previous messageGo to next message
Kevin Meade
Messages: 2103
Registered: December 1999
Location: Connecticut USA
Senior Member
I am logging from Hartford virtual desktop... and am not able to log in with my own id. The site is not allowing me to log out your account Kevin...
Re: What does "session uga memory"/"session uga memory max" signifies and how to interpret the value def [message #610186 is a reply to message #610176] Tue, 18 March 2014 06:09 Go to previous message
Kevin Meade
Messages: 2103
Registered: December 1999
Location: Connecticut USA
Senior Member
hi Kevin

Could you please change your FAQ password, let's ses if this will prevent us login here using your ID.

Avijit
Previous Topic: SQL Execution Runtime Measure
Next Topic: session uga memory
Goto Forum:
  


Current Time: Tue Nov 30 03:58:00 CST 2021