Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Profile (Idle Time Issue)

RE: Profile (Idle Time Issue)

From: DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM>
Date: Wed, 10 Mar 2004 15:49:48 -0600
Message-ID: <0186754BC82DD511B5C600B0D0AAC4D607B001A6@EXCHMN3>


Jay

   Tell the developers that their application can't be deployed until they solve their problem.

Dennis Williams
DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Jay Wade Sent: Wednesday, March 10, 2004 3:45 PM
To: oracle-l_at_freelists.org
Subject: Profile (Idle Time Issue)

Hello:
I'm running into an issue where some developers using IIS and MS.Net are developing an application which creates a connection each time it connects to the database. After performing a task they dispose the connection (at least they says they are). But it seems as though there is a build up for idle sessions (30-40). I've created an assigned a profile with the following:

  CONNECT_TIME 120
  IDLE_TIME 5 It seems like the connections for some of the users are still not being terminated. I've double checked and they are all associated with the profile. Any idea on how to terminate the idle instances? Any I missing something?

Thanks In Advance,
Jay



Get a FREE online computer virus scan from McAfee when you click here. http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963

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 Wed Mar 10 2004 - 15:54:54 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US