Re: Does inactive sessions consume RAM

From: Danisment Gazi Unal <dunal_at_ubTools.com>
Date: Thu, 27 May 2004 11:08:40 +0300
Message-ID: <014301c443c1$d44e0ad0$fe19100a@danismentgu>

Yes,

I think 'session pga memory' is the best for session memory usage. But, there may be still free chunks not shrinked yet in this statistic.

best regards...

http://www.ubTools.com
Web Based Oracle Products and Services

Original Message ----- From: "Naveen, Nahata (IE10)" <Naveen.Nahata_at_honeywell.com> To: <oracle-l_at_freelists.org> Sent: Thursday, May 27, 2004 10:58 AM Subject: RE: Does inactive sessions consume RAM

> >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
> -----------------------------------------------------------------

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 - 03:05:19 CDT