Re: Does inactive sessions consume RAM
- From: "Danisment Gazi Unal" <dunal@xxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 27 May 2004 11:08:40 +0300
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@xxxxxxxxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>
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@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
> -----------------------------------------------------------------
----------------------------------------------------------------
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:
