Database Administration (MOSC)

MOSC Banner

What and how to change/alter _cursor_db_buffers_pinned parameter

edited Mar 20, 2013 10:19PM in Database Administration (MOSC) 6 commentsAnswered
Hi,
i wonder what is the consequence of changing _cursor_db_buffers_pinned hidden parameter in the dr db.
as this parameter is regarding "additional number of buffers a cursor can pin at once".

situation:
i was told to make sure the all the parameters in the primary db need to be the same as the one in dr.
this _cursor_db_buffers_pinned is one of the parameters in dr not the same as the one in primary db.

Primary side
_cursor_db_buffers_pinned    131

DR side
_cursor_db_buffers_pinned    203


question 1:
How to alter this parameter.

question 2:
what is the impact if alter this parameter in the dr side same as the one in primary db.

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