Re: Does inactive sessions consume RAM

From: Richard Foote <richard.foote_at_bigpond.com>
Date: Thu, 27 May 2004 23:24:23 +1000
Message-ID: <03fd01c443ed$ed27b890$0100000a@FOOTE>

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_at_cetelem.fr> To: <oracle-l_at_freelists.org>
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_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 - 08:25:10 CDT