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
Job Coordinator Actions
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.
You do not need to set the time that the job coordinator checks the job table; the system chooses the time frame automatically.
One job coordinator is used per instance. This is also the case in Oracle RAC environments.
参考:http://docs.oracle.com/cd/E11882_01/server.112/e25494/schedover.htm#ADMIN13489