Oracle 视图 ALL_SCHEDULER_WINDOW_LOG 官方解释，作用，如何使用详细说明
本站中文解释
Oracle视图ALL_SCHEDULER_WINDOW_LOG用于记录Scheduler窗口的执行状态日志信息。此视图显示用于遍历和评估作业窗口条件的历史细节以及详细的信息，如执行计划的执行时间和作业的窗口条件。
使用方式：
要查看Scheduler窗口日志信息，首先需要查询ALL_SCHEDULER_WINDOW_LOG视图，该视图需要输入窗口名称和最近一次运行开始时间，可以如下查询视图：
SELECT *
FROM all_scheduler_window_log
WHERE window_name = ‘MY_WINDOW’
AND last_run_start > SYSDATE – 7;
官方英文解释
ALL_SCHEDULER_WINDOW_LOG displays log information for the Scheduler windows accessible to the current user.
Related View
DBA_SCHEDULER_WINDOW_LOG displays log information for all Scheduler windows in the database.
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
|
Unique identifier of the log entry |
|
|
|
Date of the log entry |
|
|
|
|
Owner of the Scheduler window |
|
|
|
|
Name of the Scheduler window |
|
|
|
|
Operation corresponding to the log entry |
|
|
|
|
Status of the operation, if applicable |
|
|
|
|
Name of the user who performed the operation, if applicable |
|
|
|
|
Client identifier of the user who performed the operation, if applicable |
|
|
|
|
Global user identifier of the user who performed the operation, if applicable |
|
|
|
|
Additional information on the entry, if applicable |
See Also:
“DBA_SCHEDULER_WINDOW_LOG”
