Edit the Undo Retention value - Intergraph Smart 3D - Administration & Configuration - Hexagon

Intergraph Smart 3D Project Management

Language
English
Product
Intergraph Smart 3D
Subproduct
Project Management
Search by Category
Administration & Configuration
Smart 3D Version
13

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;