Home » RDBMS Server » Performance Tuning » session uga memory
session uga memory [message #610201] Tue, 18 March 2014 07:33 Go to next message
ashu205
Messages: 1
Registered: March 2014
Junior 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

Re: session uga memory [message #610409 is a reply to message #610201] Wed, 19 March 2014 18:42 Go to previous message
BlackSwan
Messages: 25854
Registered: January 2009
Location: SoCal
Senior Member
Welcome to this forum

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/

Please learn to Read The Fine Manual yourself

http://www.oracle.com/pls/db121/search?remark=quick_search&word=session+uga+memory

Previous Topic: What does "session uga memory"/"session uga memory max" signifies and how to interpret the value def
Next Topic: statement with big cost
Goto Forum:
  


Current Time: Tue Feb 20 11:39:53 CST 2018

Total time taken to generate the page: 0.01745 seconds