Re: Does inactive sessions consume RAM
- From: "Danisment Gazi Unal (ubTools)" <dunal@xxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 27 May 2004 15:49:00 +0300
Hi,
Diego is correct.
Here is a little bit addition:
pmap has some bugs. See
http://www.solarisinternals.com/si/tools/pmap/index.php for the details.
best regards...
http://www.ubTools.com
Web Based Oracle Products and Services
----- Original Message -----
From: "Diego Cutrone" <diegocutrone@xxxxxxxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>
Sent: Thursday, May 27, 2004 7:40 PM
Subject: Re: Does inactive sessions consume RAM
> 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@xxxxxxxxxx>
> To: <oracle-l@xxxxxxxxxxxxx>
> 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@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
> -----------------------------------------------------------------
----------------------------------------------------------------
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:
