侧边栏壁纸
博主头像
与晚风述往事博主等级

万般皆下品,唯有读书高。

  • 累计撰写 149 篇文章
  • 累计创建 29 个标签
  • 累计收到 7 条评论

目 录CONTENT

文章目录

DBA_SCHEDULER_WINDOWS静态数据字典视图

与晚风述往事
2021-12-23 / 0 评论 / 0 点赞 / 225 阅读 / 1,651 字 / 正在检测是否收录...
温馨提示:
本文最后更新于 2021-12-23,若内容或图片失效,请留言反馈。部分素材来自网络,若不小心影响到您的利益,请联系我们删除。

介绍

DBA_SCHEDULER_WINDOWS视图提供了查询当前数据库中所有调度程序窗口的信息,调度程序和job类型,都可以理解为定时执行某些任务的程序。

视图详情

字段名 字段类型 描述 备注
WINDOW_NAME VARCHAR2(30) Name of the Scheduler window 调度程序窗口的名称
RESOURCE_PLAN VARCHAR2(30) Resource plan associated with the window 与窗口关联的资源计划
SCHEDULE_OWNER VARCHAR2(4000) Owner of the schedule of the window 调度程序窗口的拥有者(创建者)
SCHEDULE_NAME VARCHAR2(4000) Name of the schedule of the window 调度程序窗口的名称
SCHEDULE_TYPE VARCHAR2(8) Type of the schedule of the window: ONCE - Repeat interval is NULL NAMED - Named schedule CALENDAR - Oracle calendaring expression used as schedule 调度程序窗口的计划类型: ONCE - NAMED - CALENDAR - 用作时间表的Oracle日历表达式
START_DATE TIMESTAMP(6) WITH TIME ZONE Start date of the window (for an inline schedule) 调度程序窗口的开始时间
REPEAT_INTERVAL VARCHAR2(4000) Calendar string for the window (for an inline schedule) 调度程序窗口的执行日历表
END_DATE TIMESTAMP(6) WITH TIME ZONE Date after which the window will no longer open (for an inline schedule) 调度程序窗口的结束时间
DURATION INTERVAL DAY(3) TO SECOND(0) Duration of the window 调度程序窗口的持续时间
WINDOW_PRIORITY VARCHAR2(4) Priority of the job relative to other windows: HIGH LOW 作业相对于其他窗口的优先级: 高优先级 低优先级
NEXT_START_DATE TIMESTAMP(6) WITH TIME ZONE Next date on which the window is scheduled to start 调度程序窗口下一次运行的时间
LAST_START_DATE TIMESTAMP(6) WITH TIME ZONE Last date on which the window opened 调度程序窗口最后一次运行的时间
ENABLED VARCHAR2(5) Indicates whether the window is enabled (TRUE) or disabled (FALSE) 调度程序窗口是否启用,TRUE-已启用,FALSE-禁用
ACTIVE VARCHAR2(5) Indicates whether the window is open (TRUE) or not (FALSE) 调度程序窗口是否打开(运行),TRUE-正在执行,FALSE-没有执行
MANUAL_OPEN_TIME TIMESTAMP(6) WITH TIME ZONE Open time of the window if it was manually opened, else NULL 如果调度程序窗口时手动打开的,则显示打开时间,否则显示空
MANUAL_DURATION INTERVAL DAY(3) TO SECOND(0) Duration of the window if it was manually opened, else NULL 如果调度程序窗口时手动打开的,则显示持续时间,否则显示空
COMMENTS VARCHAR2(240) Comments on the window 调度程序窗口的描述
0

评论区