10 April, 2012

ODP.NET Slow first connection

I was having a problem with the first time the Oracle provider connection was made. I enabled the oracle log and it only started after the big delay.

Using ProcessMonitor i was finally able to verify that the w3wp process was having trouble creating some directories in the oracle client directory. 

The necessary directory structure was:

C:\oracle_client\log\diag\clients

This saved 20 seconds from the first connection delay. 

Hope it helps someone.