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
Which of the following tasks is not performed by the job coordinator?
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
A is correct:
https://docs.oracle.com/cd/E18283_01/server.112/e17120/schedover004.htm
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.