1 Reply Latest reply: Jan 10, 2013 1:25 AM by kuljeet singh - RSS

    needs solution for addm diagnostic report(open_cursors+session_cached)

    afzal
      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.