Oracle database is slow to respond

/ / Published in
Created On
byaaron
< Back

When connecting to an Oracle database, you may experience very slow responses when loading the list of Tables or Field in the configuration wizard, or when performing Autofill and Export using the Oracle connection.

This can be caused by a variety of issues:

  • Check User Permissions. Make sure the user has access to the required tables and schemas. Users with access to all schemas may experience significant delays when loading table lists as there can be many thousands of tables they have access to. Try switching to a user account whose schema only includes the tables used by SimpleIndex.
  • Slow connection between the client and the Oracle server. Check if other Oracle applications on this workstation also experience slowness.
  • Issues with client installation. Reinstall or update your Oracle client and ODBC drivers.