Re: Any ODBC and performance issues

From: <buckeye714_at_my-deja.com>
Date: Fri, 02 Feb 2001 01:46:38 GMT
Message-ID: <95d3ht$rb8$1@nnrp1.deja.com>

I want to thank everyone that replied. I also have the feeling that it's the app that's the problem. I now have some questions to ask the developers on our next conference call. Thanks for your help.

Patrick

In article <959sdl$br$1_at_nnrp1.deja.com>, buckeye714_at_my-deja.com wrote:
> 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/
>

Sent via Deja.com
http://www.deja.com/ Received on Thu Feb 01 2001 - 19:46:38 CST