I have a long running query that's timing out after an hour, but I can't find any timeout values specified. The DbCommand has its timeout set to 0. This is wrapped within an OracleTransaction, but I can't find any timeouts at that level. On the client all I'm getting is "System.InvalidOperationException: The transaction associated with the connection has completed but not yet disposed. Dispose the transaction to execute SQL statements on this connection" on ExecuteNonQuery for the *next* query. I'm not finding anything in the database alert log. I enabled tracing on the client, but I'm not sure what I'm looking for. I see an XCTEND rlbk=1 rd_only=0.
Any advice on why my query's timing out after an hour?