Req: it have been continue from last 15 hours utlrp.sql script
Hi Experts
For compile invalid objects i ran UTLRP.SQL script from sys user
From last 20 hours onwords it is runing mode
if i issue below command there is no invalid object it show
select count(*) from dba_objects where status='INVALID';
COUNT(*)
----------
0
SELECT job_name FROM dba_scheduler_jobs WHERE job_name like 'UTL_RECOMP_SLAVE_%'
SQL> /
JOB_NAME
------------------------------
UTL_RECOMP_SLAVE_32
UTL_RECOMP_SLAVE_31
UTL_RECOMP_SLAVE_30
UTL_RECOMP_SLAVE_29
UTL_RECOMP_SLAVE_28
UTL_RECOMP_SLAVE_27
UTL_RECOMP_SLAVE_26
UTL_RECOMP_SLAVE_25
UTL_RECOMP_SLAVE_24
UTL_RECOMP_SLAVE_23
UTL_RECOMP_SLAVE_22
JOB_NAME
------------------------------
UTL_RECOMP_SLAVE_21
For compile invalid objects i ran UTLRP.SQL script from sys user
From last 20 hours onwords it is runing mode
if i issue below command there is no invalid object it show
select count(*) from dba_objects where status='INVALID';
COUNT(*)
----------
0
SELECT job_name FROM dba_scheduler_jobs WHERE job_name like 'UTL_RECOMP_SLAVE_%'
SQL> /
JOB_NAME
------------------------------
UTL_RECOMP_SLAVE_32
UTL_RECOMP_SLAVE_31
UTL_RECOMP_SLAVE_30
UTL_RECOMP_SLAVE_29
UTL_RECOMP_SLAVE_28
UTL_RECOMP_SLAVE_27
UTL_RECOMP_SLAVE_26
UTL_RECOMP_SLAVE_25
UTL_RECOMP_SLAVE_24
UTL_RECOMP_SLAVE_23
UTL_RECOMP_SLAVE_22
JOB_NAME
------------------------------
UTL_RECOMP_SLAVE_21
0