Thanks for your help, I'll double check that my parameters are set
correctly.
Also, seems as though they are not disposing of the object after all......
>From: "Goulet, Dick" <DGoulet_at_vicr.com>
>Reply-To: oracle-l_at_freelists.org
>To: <oracle-l_at_freelists.org>
>Subject: RE: Profile (Idle Time Issue)
>Date: Wed, 10 Mar 2004 17:05:25 -0500
>
>Is resource_limit = true in your Init.ora file? If not then the profile is
>crippled. BTW, that's a continuous problem with people who use MicroSlop
>web development tools. Actually it's a problem with the tool, not the
>developer. I've worked with some of our ASP programmers here & seen that
>they do issue a disconnect command in the app & that the command returns
>success, whatever that means. Personally I think it's a MicroSlop thing to
>tell IIS that it can ignore that connection only. Get them to switch to
>Apache & PHP. preferably on Linux.
>
>Dick Goulet
>Senior Oracle DBA
>Oracle Certified 8i DBA
>
>-----Original Message-----
>From: Jay Wade [mailto:fish_dba_at_hotmail.com]
>Sent: Wednesday, March 10, 2004 4: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
>-----------------------------------------------------------------
Get business advice and resources to improve your work life, from bCentral.
http://special.msn.com/bcentral/loudclear.armx
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 - 17:07:13 CST
