2 Feb 2003 evilrobots   » (Observer)

select sum(decode(name,'free memory', bytes)) from v$sgastat; select sum(bytes) from v$sgastat; watch out for fast segment growth Oracle Enterprise Manager Event Test Reference Manual. Part# A89872-02
AQ Servlet
select username, value from v@session sess, v$sesstat stat, v$statname name wehre sess.SID = stat.SID and stat.statistic# = name.statistic# and name.NAME = 'session uga memory';

Latest blog entries     Older blog entries

X
Share this page