Edit the Undo Retention Value - Intergraph Smart 3D - Administration

Intergraph Smart 3D Project Management

PPMProductFamily
3D Design and Visualization
PPMProduct
Intergraph Smart 3D
PPMCategory
Administration
SPFVersion_custom
2019 (10.0)
Version_S3D
12.1(2019)

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.

  1. Open SQL *Plus on the database server.

  2. 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;