SAP Knowledge Base Article - Public

1680608 - Crystal Reports against Oracle database takes a long time to refresh


  • Crystal Reports against Oracle database takes a long time to refresh
  • Performance issue observed when running a Crystal Report against Oracle native connection


  • Crystal reports 2008 
  • SAP Crystal Reports 2016
  • Oracle database

Reproducing the Issue

  1. Create a new Crystal Report on Oracle Server connection
  2. Refresh the report, it will take a long time to refresh the report


Having “DoAutoSmartLinking” value set to 'Yes' causes Oracle to generate inefficient SQL to obtain metadata about an Oracle table, which in turn causes Crystal Reports to hang temporarily while waiting for a response from Oracle server. “Verify on First Refresh" option adds an extra call to the database to verify if the database metadata matches the report. It affects performance but not as much as SmartLinking.


  1. Create a Crystal Report based on Oracle Server Connection
  2. Go to File menu -> Report Options
  3. Uncheck the option for “Verify on First Refresh” and “Automatic Smart Linking”
  4. Performance of the report will be improved significantly

See Also

1260284 - Slow performance when reporting from multiple data sources in Crystal Reports


Crystal Reports performance issue with Oracle, Oracle 11gR2 , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem


Crystal Reports 2008 V1