Re: Does inactive sessions consume RAM

From: Diego Cutrone <diegocutrone_at_yahoo.com.ar>
Date: Thu, 27 May 2004 09:40:58 -0700
Message-ID: <013901c44409$64617700$4d8049c8@DC>

Hi Philippe,

The answer to your question is "yes". Idle Oracle processes keep consuming memory resources.
An accurate method, I know, to find out the current PGA for an Oracle process is to take a heapdump level 1 for that process. Another possibility is
to check at the OS level how much memory that process is holding, not by checking the SZ field in the standard ps but using commands such as svmon in aix or pmap in solaris.

HTH
Regards,
Diego.

Original Message ----- From: "NGUYEN Philippe (Cetelem)" <philippe.nguyen_at_cetelem.fr> To: <oracle-l_at_freelists.org> Sent: Thursday, May 27, 2004 12:33 AM Subject: 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$?)
> Thank in advance !
> Philippe
>
> ----------------------------------------------------------------
> 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 - 07:34:58 CDT