Re: Oracle, multi thread and heavy load leads to access violation in ORA73.dll

Apparently Oracle support doesn't have a full-text searchable support incident database, as this issue was logged by myself as an issue in scaling (Microsoft) MTS against an Oracle 7.3.4.3 server.

The issue is directly related to the Oracle 7.3.4.x client software, and can be solved by simply installing the 8.0.5.2.2 client. If you are using XA mode transactions then you will need a definition of a view that is missing in 7.3.4.x server (sys.dba_pending_transactions).

Mike

Suuronen Henri wrote in message <384FBE0F.36AF6C57_at_ej.insta.fi>...
>We have the following environment:
>- Oracle Server 7.3.4.5 on HP-UX 10.20
>- Oracle Client 7.3.4.5 on Windows NT 4.0 WS + SP5
>- Direct Oracle Access 3.3.1
>- Delphi 4 + update 3
>
>The problem is that when the load rises (50 transactions/sec) the
>client-side ORA73.dll starts to throw access violations. We have tracked
>this one with Oracle support to no avail (upgraded, patched etc.). The
>problem does not occur if the load is lighter. The same queries are
>repeated
>over and over again so the problem shouldn't be on our application.
>
>Problem persists on every machine we have tried and is repeatable. What
>makes it nasty is the fact that ORA73.dll does not recover until
>application is restarted (and thus dll is initialized). Also we haven't
>been able to track down the responsible party, it could Oracle server or
>client, DOA or our application.
Received on Mon Dec 13 1999 - 00:00:00 CET