The UPTIME_STEPS procedure accepts the following optional parameters.
| Parameter | Description |
|---|---|
| MAX_MINUTES | The maximum number of minutes that the procedure is permitted to
start new operations. When greater than 0, the parameter is used to set
an end time that defines when the procedure can no longer pick up new
work. This parameter helps to limit the amount of work that a procedure
is permitted to perform to help scope operations within a limited
timeframe. Applies to non-PK index creation executed by the UPTIME_STEPS procedure. The default value is defined in the DEFAULT_MAX_MINUTES column of the IN_DB_UPGRADE_CONTROL_UPGRADE table. The default value of 0 is equal to unlimited which means uptime steps will continue running until all steps have been completed. |
| PARALLEL | The degree of parallelism to use for the session. The default value is defined in the DEFAULT_PARALLEL column of the IN_DB_UPGRADE_CONTROL_UPGRADE table. The default value of 0 is equal to CPU_COUNT-2. |
| LOGGING | Used to define the default logging option for qualifying operations.
This applies to the creation of tables and indexes. Valid options are
LOGGING or NOLOGGING. Used to define the default logging option for qualifying operations. This applies to the creation of tables and indexes. Valid options are LOGGING or NOLOGGING. Note that with the NOLOGGING option, these objects will not be recoverable until they are successfully backed up. The default value is defined in the DEFAULT_LOGGING column of the IN_DB_UPGRADE_CONTROL_UPGRADE table. The default value is LOGGING. |