RE: Profile (Idle Time Issue)
- From: "Goulet, Dick" <DGoulet@xxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- 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@xxxxxxxxxxx]
Sent: Wednesday, March 10, 2004 4:45 PM
To: oracle-l@xxxxxxxxxxxxx
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@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:
