To ensure the best performance for GoldenGate, we recommend the value for the undo_retention parameter to be at least 86400. Perform the following process at the Host and all Satellite location servers that participate in the Workshare.
-
Open SQL *Plus on the database server.
-
At the command prompt, type the following:
CMD> SQLPLUS /NOLOG
SQL> CONNECT SYS/[password] AS SYSDBA
SQL> ALTER SYSTEM SET UNDO_RETENTION=86400 SCOPE=SPFILE;
SQL> SHUTDOWN IMMEDIATE;
SQL> STARTUP;
SQL> EXIT;