How to check Current Session Memory

[samdba]

Hi all,

On Windows based Oracle 8i, is there any way to check how much physical memory of the server is being utilized by each database session/connection?

Thanks in Adv.

[rohitsn]

Hi,
select n.name,s.valuefrom
v$statname n,V$sesstat swhere n.statistic# = s.statistic#and
value > 0 and
s.sid = (select a.sid from v$process p,v$session a where p.addr =a.paddr and a.audsid = userenv('sessionid'))order by n.class,n.name



Regards,
Rohit Nirkhe,Oracle/Apps DBA,OCP 8i,9i
oracle-support@indiatimes.com

[samdba]

Hi rohitsn,

This query errors out with ORA-01427 Single-row subquery returns more than one row error.

Thanks,

[DaPi]

Hi Rohit,

why do you refer to v$process ? isn't this enough?

select n.name, s.value
from  v$statname n, v$sesstat s, v$session a
where n.statistic# = s.statistic#
and   value > 0 
and   s.sid = a.sid
and   a.audsid = userenv('sessionid')
order by n.class, n.name
/