This discussion is archived
1 Reply Latest reply: Jan 9, 2013 11:25 PM by KuljeetPalSingh RSS

needs solution for addm diagnostic report(open_cursors+session_cached)

afzal Newbie
Currently Being Moderated
Hi
what is solution below addm report


Finding 4: Soft Parse
Impact is .01 active sessions, 2% of total activity.
----------------------------------------------------
Soft parsing of SQL statements was consuming significant database time.

Recommendation 1: Application Analysis
Estimated benefit is .01 active sessions, 2% of total activity.
---------------------------------------------------------------
Action
Investigate application logic to keep open the frequently used cursors
Note that cursors are closed by both cursor close calls and session
disconnects.

Recommendation 2: Database Configuration
Estimated benefit is .01 active sessions, 2% of total activity.
---------------------------------------------------------------
Action
Consider increasing the maximum number of open cursors a session can
have by increasing the value of parameter "open_cursors".
Action
Consider increasing the session cursor cache size by increasing the
value of parameter "session_cached_cursors".
Rationale
The value of parameter "open_cursors" was "600" during the analysis
period.
Rationale
The value of parameter "session_cached_cursors" was "500" during the
analysis period.

Legend

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