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 |
---|---|---|---|
|
|
|
Name of a schedule to be replayed |
|
|
|
Identifies the workload capture that will wait |
|
|
|
Identifies the workload capture for which the workload capture identified by If the view has multiple rows with the same If the view has multiple rows with the same |