Query To Track Oracle Recompilation

Query showing jobs created by UTL_RECOMP

SELECT job_name FROM dba_scheduler_jobs
WHERE job_name LIKE 'UTL_RECOMP_SLAVE_%';

Query showing UTL_RECOMP jobs that are running

SELECT job_name FROM dba_scheduler_running_jobs
WHERE job_name LIKE 'UTL_RECOMP_SLAVE_%';

Query returning the number of invalid objects remaining. This
number should decrease with time.

SELECT COUNT(*) FROM obj$ WHERE STATUS IN (4, 5, 6);

Query returning the number of objects compiled so far. This number
should increase with time.

SELECT COUNT(*) FROM UTL_RECOMP_COMPILED;

SELECT count(*) FROM dba_objects WHERE STATUS='INVALID';