RE: Does inactive sessions consume RAM
- From: "Naveen, Nahata (IE10)" <Naveen.Nahata@xxxxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Thu, 27 May 2004 00:58:58 -0700
>Hi list,
>I have an instance with many inactive sessions because my users always
>forgot to disconnect from db.
>Does thoses sessions consume RAM or any resources ?
>How can I prove it ? (which v$?)
Every session occupies some memory.
This script tells you the memory usage by a session
select s.sid, n.name, s.value
from v$sesstat s,
v$statname n,
v$session sess
where n.statistic# = s.statistic#
and s.sid = sess.sid
and sess.status = 'INACTIVE'
and n.name like '%memory%'
and n.name not like 'sorts (memory)'
order by s.sid
;
Regards
Naveen
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts: