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: 443
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