在 Oracle 性能监控中，为什么 Scheduler 活动会增加
Oracle中的调度程序是什么意思？ 是连接调度还是查询调度还是查询计划执行调度还是其他什么？
What does scheduler mean in Oracle?
Is it connection scheduling or query scheduling or the query plan execution scheduling or something else?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（3）
在 10g 及更高版本中，术语“调度程序”通常指在该版本中引入的新 Oracle 作业调度程序下运行的进程。在 10g 之前，有一个功能较少的调度程序，并且在该调度程序下运行的作业通常称为“dbms 作业”，因为用于管理它们的 API 是 PL/SQL 内置包 DBMS_JOB。
其他信息：
11g 版本的 API -
新的工作是DBMS_SCHEDULER
增强功能，例如能力
运行 PL/SQL 块以外的目标，
日志记录、维护接口
windows 和更友好的规范
之间的时间间隔
Enterprise
版本将创建多个
开箱即用的 DBMS_SCHEDULER 作业 -
可能是你唯一的一个
需要修改/更换/重新安排是
计算统计数据的作业
优化器。
In 10g and above, the term "scheduler" usually refers to the processes that are running under the new Oracle job scheduler that was introduced in that release. Prior to 10g, there was a less functional scheduler and jobs that were running under that were usually referred to as "dbms jobs" because the API used to manage them was the PL/SQL built-in package DBMS_JOB.
Other info:
of the 11g release - the API for the
new jobs is DBMS_SCHEDULER
enhancements such as the ability to
run targets other than PL/SQL blocks,
logging, interfaces to maintenance
windows, and friendlier specification
of the time intervals between
executions
Edition will create several
DBMS_SCHEDULER jobs out of the box -
probably the only one you'll ever
need to modify/replace/reschedule is
the job that computes statistics for
the optimizer.
在这种情况下，我怀疑您的意思是调度程序而不是在特定时间运行作业。 （它曾经是通过 DBMS_JOB 调用/访问的，如果这敲响了警钟的话？）
我猜测性能监视器会安排定期作业来查看查询统计信息等，因此活动会增加。
In this case I suspect you mean the scheduler than runs jobs at certain times. (It used to be called/accessed via DBMS_JOB if that rings any bells?)
I would guess that the Performance Monitor schedules regular jobs to look at query statistics etc, hence the increase in activity.
正常查询很可能是由资源管理器控制的。在这种情况下，您会看到网格控制中等待调度程序，而无需运行单个计划作业。
此致，
罗纳德
It could very well be that normal queries are controlled by resource manager. In that case you see waits for scheduler in grid control, without having run a single scheduled job.
best regards,
Ronald