Cheeky Cockatoo

Life Advice and Stories, Travel, Oracle Tech, Good Food and More

user_sess_mem_max.sql

Download Script

select value sess_mem
from v$sesstat s, v$statname n
where s.statistic# = n.statistic#
and n.name= 'session uga memory max'
and s.sid = &1 ;