ASP.NET Oracle ODP.NET Integrated Security Slowness

The following results in successful sub-second page loads.

<add name="test" 
    connectionString="Data Source=TEST_ORACLE;User Id=user;Password=password;" />

The following subtle change to use the app pool's custom identity results in successful page l开发者_如何学Pythonoads that are 20+ times slower.

<add name="test" 
    connectionString="Data Source=TEST_ORACLE;User Id=/;" />

It appears that I at least got the trusted connection to work. What am I missing?

Try Integrated Security=SSPI; instead of User Id=/;

Does your app pool identity have network logon rights?

The connections strings that I use look like

<add 
    name="myOracleConnection" 
    connectionString="Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=MyServer)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=XE))); User Id=MyUser; Password=MyPassword;" 
    providerName="system.data.oracleclient"/>

I.e. I do not rely on these external configuration files (were they named .ora? I forgot it).

Maybe you can lower dependencies and side-effects if you also try to make your connection string self-containing with everything included?