Register Login

How to check utlrp.sql running in background or not?

Updated May 18, 2018

Hi All,
How to check utlrp.sql running in background or not?
Recently executed utlrp.sql 2 hours later session got disconnected. Now I want to know ultrp will be running or not. When I check for invalid objects. Still its varying .

If anyone is familiar with such errors then please help me in solving this query.

 

Thanks in Advance!

 


Comments

  • 28 Mar 2015 3:37 pm Romil Tripathi

    If it got disconnected on its own then it means its not running. You can verify that in gv$session to see if any session waits are there under that program and you can also check the last_ddl_time under dba_objects or user_objects if you remember the invalid objects and their count before running it to verify if utlrp.sql has actually compiled the invalid objects or not.

  • 28 Mar 2015 3:37 pm Romil Tripathi

    Besides there is no impact in rerunning it.

  • 28 Mar 2015 3:38 pm Abhijeet Mudgal

    I checked in dba_objects but its gradually decreasing and sometimes increasing.

  • 28 Mar 2015 3:39 pm Romil Tripathi

    See if there is anything under session long hops / long running sessions under gv$session. if its there then kill it then no harm in rerunning it.


×