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.
Printable View
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.
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
Hi rohitsn,
This query errors out with ORA-01427 Single-row subquery returns more than one row error.
Thanks,
Hi Rohit,
why do you refer to v$process ? isn't this enough?
Code: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
/