Database Administration (MOSC)

MOSC Banner

open_cursors is different between PROD and DR

Hi,

I have changed open_cursors to 400 on PROD database version 19.11 (5.11 sparc), however, I can not find this change on DR, and there is no DR gap. I am wondering why DR can be different with PROD for open_cursors setting? How should I let the DR to be the same as PROD? Tks.

Some details are as below:

On PROD:

SQL> show parameter open_cursors;

NAME                                      TYPE       VALUE

------------------------------------ ----------- ------------------------------

open_cursors                        integer    50

SQL> ALTER SYSTEM SET open_cursors = 400 SCOPE=BOTH;

System altered.

SQL> show parameter open_cursors;

NAME                                       TYPE       VALUE

------------------------------------ ----------- ------------------------------

open_cursors                        integer    400    


On DR:

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