ITPub博客

首页 > 数据库 > Oracle > Oracle OCP IZ0-053 Q448(Job Coordinator)

Oracle OCP IZ0-053 Q448(Job Coordinator)

原创 Oracle 作者:abstractcyj 时间:2016-03-17 17:15:56 0 删除 编辑
448.Which of the following tasks is not performed by the job coordinator?
A. Update job log when a job completes
B. Spawn and remove job slaves
C. Write/read job info to/from memory cache
D. Query job table
E. Pass job information to job slaves
Answer: A

http://docs.oracle.com/cd/E18283_01/server.112/e17120/schedover004.htm
http://www.aiotestking.com/oracle/which-of-the-following-tasks-is-not-performed-by-the-job-coordinator/

The Job Coordinator

The job coordinator background process (cjqNNN) is automatically started and stopped on an as-needed basis. At database startup, the job coordinator is not started, but the database does monitor whether there are any jobs to be executed, or windows to be opened in the near future. If so, it starts the coordinator.

As long as there are jobs or windows running, the coordinator continues to run. After there has been a certain period of Scheduler inactivity and there are no jobs or windows scheduled in the near future, the coordinator is automatically stopped.

When the database determines whether or not to start the job coordinator, it takes the service affinity of jobs into account. For example, if there is only one job scheduled in the near future and this job belongs to a job class that has service affinity for only two out of the four Oracle RAC instances, only the job coordinators for those two instances are started. See "Service Affinity when Using the Scheduler" for more information.

The job coordinator:

  • Controls and spawns the job slaves

  • Queries the job table

  • Picks up jobs from the job table on a regular basis and places them in a memory cache. This improves performance by reducing trips to the disk

  • Takes jobs from the memory cache and passes them to job slaves for execution

  • Cleans up the job slave pool when slaves are no longer needed

  • Goes to sleep when no jobs are scheduled

  • Wakes up when a new job is about to be executed or a job was created using the CREATE_JOB procedure

  • Upon database, startup after an abnormal database shutdown, recovers any jobs that were running.


来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/8520577/viewspace-2058977/ ,如需转载,请注明出处,否则将追究法律责任。

下一篇: Oracle IZ0-053 Q327
请登录后发表评论 登录
全部评论
曾从事java方向开发多年。近年已经转入数据库方向。主要擅长SQL优化,Oracle数据库问题诊断,Oracle备份与恢复等。服务于医药物流,医院等行业

注册时间:2010-01-26

  • 博文量
    602
  • 访问量
    1091623