Database Administration (MOSC)

MOSC Banner

SESSION_CACHED_CURSOR on instance level

edited Dec 11, 2012 7:50PM in Database Administration (MOSC) 5 commentsAnswered
Team,
I am using Oracle 11.2.0.2.0 on a linux system.

I am confused about SESSION_CACHED_CURSOR. Is it on session level or instance level?

Oracle ADDM report shows:
Recommendation 2: Database Configuration
   Estimated benefit is .14 active sessions, 9.29% of total activity.
   ------------------------------------------------------------------
   Action
      Consider increasing the session cursor cache size by increasing the
      value of parameter "session_cached_cursors".
   Rationale
      The value of parameter "session_cached_cursors" was "50" during the
      analysis period.
Suggestion: set session_cached_cursors to 150.

How to increase SESSION_CACHED_CURSOR on instance level? That it will be increased for all sessions?

Hisham

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center