The UPTIME_STEPS procedure accepts the following optional parameters.
| Parameter | Description |
|---|---|
| PARALLEL | The degree of parallelism 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. If shipping archived redo logs for replication, then use LOGGING. Otherwise, consider using NOLOGGING to reduce logging during the creation of indexes to improve performance. 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. |
| MAX_CONNECTIONS | Used to specify how many DB connections to allow during the downtime
connections checks. If the number of connections exceed this number,
then the upgrade will not begin. This check is based on the results of the following function: SELECT IN_DB_UTIL.GET_DB_CONNECTIONS_COUNT FROM DUAL; The default value is 5. |