The SYNC_SETUP procedure accepts the following optional parameters.
| Parameter | Description |
|---|---|
| TABLE_NAME | The source table name for the synchronization process. Currently, only the IN_DOC table qualifies for synchronization. |
| KEEP_SRC_TABLE | Used to specify whether to keep the original/source IN_DOC table upon
successful completion of the downtime steps. If YES, then the source
table will be renamed and saved after the downtime event. If NO, then
the source table will be dropped at the end of the downtime event, which
will free up the storage it is consuming. The default value is YES to keep the original table and its PK constraint and index. |
| DATA_TS_NAME | The name of the tablespace to create the new IN_DOC table in. The
user must have a sufficient quota on the specified tablespace. The default value is the current tablespace of the IN_DOC table. |
| INDX_TS_NAME | The name of the tablespace to create the new IN_DOC table indexes in.
The user must have a sufficient quota on the specified tablespace.
The default value is MAX(TABLESPACE_NAME) from ALL_INDEXES for the IN_DOC table. |
| MAX_MINUTES | Used to define the default maximum number of minutes that a
synchronization procedure is permitted to start new operations. When
greater than 0, the parameter is used to set an end time that defines
when a procedure can no longer pick up new work. This parameter helps to
limit the amount of work that a process is permitted to perform to help
scope operations within a defined timeframe. Applies to table synchronization (SYNC_TABLE_IN_DOC) and non-PK index creation executed by the UPTIME_STEPS procedure. The default value of 0 is equal to unlimited. |
| BATCH_SIZE | Used to define the default batch size for the SYNC_TABLE_IN_DOC
procedure. The batch size defines the number of rows to fetch (BULK
COLLECT) into the synchronization work queue (cursor) for each batch.
The default value is 50,000 rows. |
| BULK_LIMIT | Used to define a limit on the number of rows fetched from the cursor
by the bulk collect operation during the SYNC_TABLE_IN_DOC procedure.
This helps reduce the memory utilization (PGA) for the process. The default value is 10,000 rows. |
| VALIDATE_FK | Used to determine if the foreign key constraints, to and from the new
IN_DOC table, should be validated after creation. If set to NO, then the
SQL to manually validate the FK constraints will be displayed but not
executed and must be manually executed as soon as possible after the
upgrade. The Foreign Key validation portion of the downtime steps is by far the longest part of the downtime for larger databases. If you are comfortable with the state of the synchronization process heading into the downtime then you can reduce your overall downtime duration by setting this parameter to NO and deferring the FK validation as a manual step after the downtime has completed. The default value of YES means the FK constraints are validated as part of the downtime steps. |
| TABLESPACE_NAME | The name of the tablespace to create the synchronization control
table and synchronization framework tables in. The default value is the current location of the IN_UPGRADE_TABLE_STATS table. |