English

Problem: Performance issues running SDE 3.0.2.1 with Oracle 7.3.4

Solution or Workaround

Summary

Running SDE 3.0.2.1 with Oracle 7.3.4 gives poor performance.

Cause
If using SDE 3.0.2.1 with Oracle 7.3.4, query performance might be slow. This may be due to a hint that is generated by SDE to Oracle, which sometimes forces Oracle to perform a full table scan to satisfy some queries.

Solution

There is a patch that deals with this performance issue.

This problem does not occur with other versions of SDE, or with versions of SDE 3.0.2.1 when used with Oracle 8 and above.

Note:
The configuration of SDE 3.0.2.1 with Oracle 7.3.4 was not certified by Esri, but is supported.

Contact Esri Technical Support if this patch is required.