Have you set RESOURCE_LIMIT to true, i.e. ALTER SYSTEM SET RESOURCE_LIMIT = TRUE Otherwise, the profile can be created and assigned to a user but it won't actually limit resource usage. Is there any chance that the developers are configuring a connection pool on the middle tier? That would certainly account for 30-40 idle connections if that corresponds to the size of the connection pool they're using. It could also explain why some connections aren't being closed-- they may be used just often enough not to trigger the profile's idle limit. It would be a rare web application indeed that wanted to open and close a physical connection to the database whenever a web page was requested. If the number of idle connections keeps growing over time, of course, there is probably a problem in their application logic. Justin Cave Distributed Database Consulting, Inc. http://www.ddbcinc.com/askDDBC -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Jay Wade Sent: Wednesday, March 10, 2004 2: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 -----------------------------------------------------------------