| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> 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
> 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
> -----------------------------------------------------------------
-- 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:45:46 CDT
 |
 |