DBA_ROLLING_PLAN displays the instructions which constitute the active upgrade plan. Each row in DBA_ROLLING_PLAN identifies a specific instruction scheduled to execute at a specific database. Instructions are created as a result of successful calls to the DBMS_ROLLING.BUILD_PLAN procedure.
During execution, groups of instructions are scheduled in batches to execute at remote databases. Groups of instructions are guaranteed to complete in BATCHID order.
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
Plan revision number associated with an instruction |
|
|
|
|
Identifier for a batch of instructions which are requested together |
|
|
|
|
Identifier for a single instruction |
|
|
|
|
Database unique name where an instruction executes |
|
|
|
|
The site where a given instruction will execute |
|
|
|
|
rolling operation phase in which an instruction executes |
|
|
|
|
Scheduling status of the instruction |
|
|
|
|
Execution progress of the instruction |
|
|
|
|
Description of the instruction |
|
|
|
|
Status code returned from instruction execution |
|
|
|
|
Supplemental information obtained during instruction execution |
|
|
|
|
Time of instruction execution |
|
|
|
|
Time of instruction completion |
See Also:
Oracle Data Guard Concepts and Administration for more information about rolling operations.
Oracle Database PL/SQL Packages and Types Reference for more information about the DBMS_ROLLING package