Changing value for stats_history_retention in dataguard setup
edited Aug 18, 2013 3:23PM in High Availability Data Guard, Sharding and Global Data Services (MOSC) 4 commentsAnswered
Hi,
While changing stats_history_retention
SQL> select dbms_stats.get_stats_history_retention from dual; -> result: 31 (primary and standby)
SQL>exec DBMS_STATS.ALTER_STATS_HISTORY_RETENTION(30);
SQL> select dbms_stats.get_stats_history_retention from dual; -> result: 30 (Primary)
Performed serveral archive log switches and checked the standby database (database role: physical standby and open_mode: read only with apply)
select dbms_stats.get_stats_history_retention from dual; -> result: 31
What will be correct syntax to change value in dataguard setup
Regards,
Vivek
While changing stats_history_retention
SQL> select dbms_stats.get_stats_history_retention from dual; -> result: 31 (primary and standby)
SQL>exec DBMS_STATS.ALTER_STATS_HISTORY_RETENTION(30);
SQL> select dbms_stats.get_stats_history_retention from dual; -> result: 30 (Primary)
Performed serveral archive log switches and checked the standby database (database role: physical standby and open_mode: read only with apply)
select dbms_stats.get_stats_history_retention from dual; -> result: 31
What will be correct syntax to change value in dataguard setup
Regards,
Vivek
0