How do I notify Oracle that an IIS Worker Process is about to recycle?

Posted by Brien on Server Fault See other posts from Server Fault or by Brien
Published on 2010-05-04T14:50:25Z Indexed on 2010/05/04 14:58 UTC
Read the original article Hit count: 415

Filed under:
|
|
|

I have an ASP.NET web application with an Oracle back end. The worker process recycling in IIS is set for 40 minutes, and when that occurs, the Oracle server sets a mutex lock while it cleans up all of its open connections. During this cleanup (up to a few minutes in duration), all DB requests get a timeout.

Is there a way for IIS to notify Oracle that a worker process recycle is about to occur, so Oracle can be smarter about how it cleans up its resources without locking the entire database?

© Server Fault or respective owner

Related posts about iis

Related posts about Oracle