Oracle 视图 ALL_SCHEDULER_WINDOW_DETAILS 官方解释，作用，如何使用详细说明
本站中文解释
Oracle视图ALL_SCHEDULER_WINDOW_DETAILS用于查询现存的调度器窗口的详细信息。窗口是调度器中的重要组件，它定义了可以执行作业的时间段。Oracle视图ALL_SCHEDULER_WINDOW_DETAILS将查询数据库中所有用户创建的调度器窗口。包括每个窗口的名称、起始时间、下一个触发时间、窗口类型、作业名称以及窗口是否正在执行等等。使用该视图时，需要定义窗口名称，以便精确查询指定的窗口详细信息。
官方英文解释
ALL_SCHEDULER_WINDOW_DETAILS displays log details for the Scheduler windows accessible to the current user.
Related View
DBA_SCHEDULER_WINDOW_DETAILS displays log details for all Scheduler windows in the database.
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
Unique identifier of the log entry (foreign key of the |
|
|
|
|
Date of the log entry |
|
|
|
|
Owner of the Scheduler window |
|
|
|
|
Name of the Scheduler window |
|
|
|
|
Requested start date for the Scheduler window |
|
|
|
|
Actual start date of the Scheduler window |
|
|
|
|
Requested duration of the Scheduler window |
|
|
|
|
Actual duration for which the Scheduler window lasted |
|
|
|
|
Identifier of the instance on which the window was run |
|
|
|
|
Additional information on the entry, if applicable |
See Also:
“DBA_SCHEDULER_WINDOW_DETAILS”
