RE: Does inactive sessions consume RAM

From: Naveen, Nahata (IE10) <Naveen.Nahata_at_honeywell.com>
Date: Thu, 27 May 2004 00:58:58 -0700
Message-ID: <77ED2BF75D59D1439F90412CC5B109740C717DA3@ie10-sahara.hiso.honeywell.com>

>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_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Thu May 27 2004 - 02:48:05 CDT