OraFAQ Forum: Performance Tuning » session uga memory

Home » RDBMS Server » Performance Tuning » session uga memory

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

session uga memory [message #610201]

Tue, 18 March 2014 07:33

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

Report message to a moderator