This discussion is archived
5 Replies Latest reply: Jan 17, 2013 7:08 AM by Dafo RSS

needs solution for addm diagnostic report

afzal Newbie
Currently Being Moderated
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.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points