Use the following queries to track recompilation progress

1. Query showing jobs created by UTL_RECOMP

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

2. Query showing UTL_RECOMP jobs that are running

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


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


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

2. 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';

No comments: