-
How to check Current Session Memory
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.
Sam
------------------------
To handle yourself, use your head. To handle others, use your heart
-
Re: How to check Current Session Memory
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
-
Re: Re: How to check Current Session Memory
Hi rohitsn,
This query errors out with ORA-01427 Single-row subquery returns more than one row error.
Thanks,
Sam
------------------------
To handle yourself, use your head. To handle others, use your heart
-
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
/
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|