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