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: