RE: Does inactive sessions consume RAM

  • From: "NGUYEN Philippe (Cetelem)" <philippe.nguyen@xxxxxxxxxx>
  • To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 27 May 2004 15:50:51 +0200

thanks to all for your answers !
PS : my wife would had never come to see T3 with me ;-)
> ____________________________________________________
> Philippe Nguyen
> CETELEM - Administration, Architecture Décisionnelle
> Direction Customer Relationship Management
> E-Mail : philippe.nguyen@xxxxxxxxxx
> Tel  : (+33) 1 46 39 92 16 - Fax : (+33) 1 46 39 59 88
> 


-----Message d'origine-----
De : oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]De la part de Richard Foote
Envoyé : jeudi 27 mai 2004 15:24
À : oracle-l@xxxxxxxxxxxxx
Objet : Re: Does inactive sessions consume RAM


Hi Nguyen,

Let me answer your question this way.

You go to see a romantic comedy movie with your wife, because she previously
agreed to see Terminator 3 with you. Try as you might, you just can't keep
your eyes open and as you polish off the last piece of popcorn, you nod off.

As you sit there "inactively", do you still occupy a cinema seat ?

Cheers ;)

Richard
----- Original Message -----
From: "NGUYEN Philippe (Cetelem)" <philippe.nguyen@xxxxxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>
Sent: Thursday, May 27, 2004 5:33 PM
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: