Oracle 视图 DBA_WORKLOAD_SCHEDULE_ORDERING 官方解释，作用，如何使用详细说明

本站中文解释

Oracle视图DBA_WORKLOAD_SCHEDULE_ORDERING是一个特殊的数据字典视图，它用来报告Oracle Database中已安排活动的工作负载调度器实例的控制选项。它还可以显示以下信息：使用此实例定义的调度器顺序、命名空间、描述、服务ID、活动调度器client、调度器实例名和控制变量。

使用Oracle视图DBA_WORKLOAD_SCHEDULE_ORDERING的方法如下：

1.使用select * from DBA_WORKLOAD_SCHEDULE_ORDERING；查询数据库中所有的活动负荷调度实例的控制变量：

2.使用Where子句以限制查询结果：
SELECT *
FROM dba_workload_schedule_ordering
WHERE SCHEDULER_ORDERING_ID = ‘1’;

3.使用order by子句以排序查询结果：
SELECT *
FROM dba_workload_schedule_ordering
ORDER BY SCHEDULER_ORDERING_ID;

官方英文解释

DBA_WORKLOAD_SCHEDULE_ORDERING displays the start ordering between workload captures in the replay schedule.

Each row in the view defines one start ordering between two workload captures in the same replay schedule.

Column Datatype NULL Description

Column	Datatype	NULL	Description
`SCHEDULE_NAME`	`VARCHAR2(128)`	`NOT NULL`	Name of a schedule to be replayed
`SCHEDULE_CAP_ID`	`NUMBER`	`NOT NULL`	Identifies the workload capture that will wait
`WAITFOR_CAP_ID`	`NUMBER`	`NOT NULL`	Identifies the workload capture for which the workload capture identified by `SCHEDULE_CAP_ID` needs to wait. The replay of capture `SCHEDULE_CAP_ID` will not start until capture `WAITFOR_CAP_ID` finishes its replay. If the view has multiple rows with the same `SCHEDULE_CAP_ID` but different `WAITFOR_CAP_ID`, it defines a schedule so that the replay of a capture specified by `SCHEDULE_CAP_ID` will not start unless all the replays of the waited captures run into completion. If the view has multiple rows with the same `WAITFOR_CAP_ID` but different `SCHEDULE_CAP_ID`, it defines a schedule so that the replay of multiple captures will not start unless the replay of the capture specified by `WAITFOR_CAP_ID` finishes.

SCHEDULE_NAME

VARCHAR2(128)

NOT NULL

Name of a schedule to be replayed

SCHEDULE_CAP_ID

NUMBER

NOT NULL

Identifies the workload capture that will wait

WAITFOR_CAP_ID

NUMBER

NOT NULL

Identifies the workload capture for which the workload capture identified by SCHEDULE_CAP_ID needs to wait. The replay of capture SCHEDULE_CAP_ID will not start until capture WAITFOR_CAP_ID finishes its replay.

If the view has multiple rows with the same SCHEDULE_CAP_ID but different WAITFOR_CAP_ID, it defines a schedule so that the replay of a capture specified by SCHEDULE_CAP_ID will not start unless all the replays of the waited captures run into completion.

If the view has multiple rows with the same WAITFOR_CAP_ID but different SCHEDULE_CAP_ID, it defines a schedule so that the replay of multiple captures will not start unless the replay of the capture specified by WAITFOR_CAP_ID finishes.