5 Replies Latest reply: Jan 17, 2013 9:08 AM by Dafo RSS

    needs solution for addm diagnostic report

    afzal
      Hi All,

      i found following details in addm report
      how can resolve these problem


      Finding 5: Hard Parse Due to Literal Usage
      Impact is .01 active sessions, 1.43% of total activity.
      -------------------------------------------------------
      SQL statements were not shared due to the usage of literals. This resulted in
      additional hard parses which were consuming significant database time.

      Recommendation 1: Application Analysis
      Estimated benefit is .01 active sessions, 1.43% of total activity.
      ------------------------------------------------------------------
      Action
      Investigate application logic for possible use of bind variables instead
      of literals.
      Action
      Alternatively, you may set the parameter "cursor_sharing" to "force".

      Symptoms That Led to the Finding:
      ---------------------------------
      Hard parsing of SQL statements was consuming significant database time.
      Impact is .02 active sessions, 2.85% of total activity.