Database Administration (MOSC)

MOSC Banner

session_cached_cursors and shared

edited Jan 26, 2014 9:22PM in Database Administration (MOSC) 6 commentsAnswered
I received a recommendation to increase session_cached_cursors parameter.

I'm having 11.2.0.4. We are using memory_target=8GB

Increasing this parameter will cause shared_pool to increase. Questions:

1) Since we are using memory_target we cannot increase shared_pool. Will the shared_pool increase by Oracle in this case?

2) What would be optimal value? I did not get this recommendation. Our open_cursors is 1024. Do we need to increase it that much?

Thanks

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