| 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: Profile (Idle Time Issue)
Jay,
Are the sessions still there but with a status of killed or sniped?
If so, you could have a separate job come along and kill off at the OS level all killed / sniped sessions
HTH,
Bruce Reardon
NOTICE: This e-mail and any attachments are private and confidential and may contain legally privileged information. If you are not an authorised recipient, the copying or distribution of this e-mail and any attachments is prohibited and you must not read, print or act in reliance on this e-mail or attachments. This notice should not be removed.
-----Original Message-----
On Behalf Of DENNIS WILLIAMS
Sent: Thursday, 11 March 2004 8:50 AM
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-----
On Behalf Of Jay Wade
Sent: Wednesday, March 10, 2004 3:45 PM
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
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.htmlReceived on Wed Mar 10 2004 - 16:07:07 CST
-----------------------------------------------------------------
 |
 |