jobQueue.htm
04-06-2002 Bikle
-----------------

Job Queue

To be completed later.


Job Queue init params

gone: SNP, job_queue_interval 

new: CJQ0 mn: coordinate job queue
J001,J002,J003 these are job runners
same: job_queue_processes (this is dynamic?)

I need to compare the 9i job design to the 8i 
and talk about performance implications.

Since job_queue_interval is gone, do I worry that
CJQ0 will drain CPU more than before since it
is more frequently active?

some dictionary views:

DBA_JOBS
All jobs in the database

DBA_JOBS_RUNNING
All jobs in the database which are currently running, join v$lock and job$


To be completed later.