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

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

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