Thursday, April 21, 2011

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.

No comments:

Post a Comment