Re: Does inactive sessions consume RAM

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

Other related posts: