OraFAQ Forum: Performance Tuning » What does "session uga memory"/"session uga memory max" signifies and how to interpret the value def

Home » RDBMS Server » Performance Tuning » What does "session uga memory"/"session uga memory max" signifies and how to interpret the value def (general)

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

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

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

Report message to a moderator

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

cookiemonster
Messages: 13963
Registered: September 2008
Location: Rainy Manchester

Senior Member

How are you logged in as Kevin Meade?

Report message to a moderator

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

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

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...

Report message to a moderator

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

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

Report message to a moderator

Previous Topic:	SQL Execution Runtime Measure
Next Topic:	session uga memory

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Feb 13 00:13:59 CST 2025