Any ODBC and performance issues

From: <buckeye714_at_my-deja.com>
Date: Wed, 31 Jan 2001 20:26:44 GMT
Message-ID: <959sdl$br$1@nnrp1.deja.com>

Scenario: Third party application. Run's on Windows (Various versions). It was written for MS Access. We use Oracle 8.1.6 on Solaris. (The vendor modified the code for use with Oracle). A process that reads and updates 32,000 records takes 32 hours to run. Vendor says it runs fine with Access. I have monitored the database and it is running well. Buffer Cache, Dictionary Cache and SQL cache hit ratios are all above 98%. No I/O problems. No wait events.

Desired: Information on possible ODBC problems. We are not experiencing network problems. The dml is using indexes as expected. The transactions don't take long on the database side. I would like to rule out the ODBC connection as the problem, but have not worked with ODBC very much. Can any one recommend a source for information on ODBC?

Thanks in advance.

Patrick

Sent via Deja.com
http://www.deja.com/ Received on Wed Jan 31 2001 - 14:26:44 CST