Real-Time Lookup May Be Unexpectedly Slow On An Oracle 10.2 Database.

April 13, 2009 | KB: 1012191
Quick Fields 7

Summary

When querying an Oracle 10.2 database, Real-time Lookup performance is unexpectedly slow.

Workaround

This issue may occur if you have recently upgraded from a previous version of Oracle to Oracle 10g. Please see the following Oracle MetaLink (https://metalink.oracle.com/CSP/ui/index.html) notes:

  • Note.257828.1 Ext/Pub Full Table Scan While Querying DATE Columns Using Oracle ODBC Driver.
  • Note.403198.1 Ext/Pub Full Index Scan in Execution Plan With Access and Double or Float as Primary Key.
  • Note.373129.1 Ext/Pub Slow Performance Exhibited by Oracle ODBC Against 10.2 Oracle Database.