How-to check an oracle session’s uga/pga

A handy sql to get the session uga/pga usage:

SQL> 
select s.sid,n.name,s.value/power(1024,2) MB 
from v$sesstat s, V$STATNAME n
where s.sid=&sid
and s.statistic# = n.statistic#
and n.NAME like 'session%memory%'
;
Enter value for sid: 13974
old 3: where s.sid=&sid
new 3: where s.sid=13974

SID NAME MB
---------- ---------------------------------------------------------------- ----------
13974 session uga memory 5.45359039
13974 session uga memory max 7.1341629
13974 session pga memory 556.797783
13974 session pga memory max 556.797783

Advertisements

About Alex Zeng
I would be very happy if this blog can help you. I appreciate every honest comments. Please forgive me if I'm too busy to reply your comments in time.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: