Oracle 视图 DBA_ROLLING_PLAN 官方解释，作用，如何使用详细说明
本站中文解释
_CHANGESVIEW
Oracle 中DBA_ROLLING_PLAN_CHANGESVIEW视图是一种系统管理视图，可用于跟踪在实例范围内滚动的计划变更。它显示实例范围内每个活动滚动计划都需要具体完成多少变更（在SQL池中执行这些变更）。
DBA_ROLLING_PLAN_CHANGESVIEW的用途：
* 它可以帮助系统管理员掌握数据库实例内滚动计划的变更情况。
* 它可以显示在执行过一次滚动计划之后，需要下一次滚动计划多少变更，以及这些变更是用于对象范围内的什么操作。
* 此视图也可以帮助检查那些未能在计划滚动时执行变更，从而减少性能影响。
要使用DBA_ROLLING_PLAN_CHANGESVIEW，需要在SQL*Plus环境中运行以下查询语句：
SELECT * FROM DBA_ROLLING_PLAN_CHANGESVIEW;
官方英文解释
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 theDBMS_ROLLINGpackage
