Ebusiness Suite Health Check : Discoverer Viewer Tuning

Discoverer Viewer Tuning

• Disable Query Prediction by setting QPPEnable=0 in pref.txt.
  
  • Set ObjectsAlwaysAccessible=1 to avoid extra workbook SQL validation, and related dictionary SQL.
    
  • Set the Query Governor option "Limit retrieved query data to:" to 100 rows.
    
  • Set the option "After opening a worksheet:" to "Don't run query."
    
  • Ensure Custom workbooks define mandatory parameters.
    

  
   

  
   

• Upgrade to Discoverer 10g (10.1.2.2)
  
  • Refer to MetaLink Note 313418.1
    
• Discoverer 10g Tuning
  
  • Enable SQL Flattening Feature - SQLFlatten=1
    
    • Significantly reduces sharable memory and parse time of
      

    SQL statements generated by Discoverer
    

  • Enable Item trimming - SQLItemTrim=1
    
    • Eliminates unused items from the SQL statement
      
  • Enable Join trimming - SQLJoinTrim=1
    
  • Eliminates joins which are not needed based on the selection.