SESSION_CACHED_CURSOR on instance level
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