Allocate streams pool size - Intergraph Smart 3D - Administration & Configuration - Hexagon PPM

Intergraph Smart 3D Global Workshare (Oracle)

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

Smart 3D uses the Integrated Capture mode for reading data. For Integrated Capture mode, Oracle requires that the streams pool size value be set to handle heavy workloads from the extract processes. To do this, you must set the value to prevent performance and memory issues with the Oracle database.

Perform the following procedure at the Host and all of the Satellite location servers that participate in the Workshare.

  1. Open SQL *PLUS, and connect as a user with SYSDBA privileges.

  2. Open SQL *Plus on the database server.

  3. At the command prompt, type the following:

    CMD> SQLPLUS /NOLOG

    SQL> CONNECT SYS/[password] AS SYSDBA

    SQL> ALTER SYSTEM SET STREAMS_POOL_SIZE=1280M SCOPE=SPFILE;

    SQL> SHUTDOWN IMMEDIATE;

    SQL> STARTUP;

    SQL> EXIT;

  • You can increase the value as additional configurations are added to the location. Set this value using the following formula:

    (1G*NUMBER_OF_SETUPS) + 25% head room

    25% must be added for every catalog and model database added to an existing Workshare.

  • 1G is the default MAX_SGA_SIZE used by Smart 3D's GoldenGate setup.

  • If this value is minimized, you might experience problems with backing up and restoring. If such errors arise, then try increasing the value size and retry the operation.