Database Administration (MOSC)

MOSC Banner

Req: it have been continue from last 15 hours utlrp.sql script

edited Nov 21, 2012 4:02AM in Database Administration (MOSC) 8 commentsAnswered
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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center