Home What is Oracle? Oracle Training Tutorials for Beginners Difference Between Oracle 11g and 12c and 10g Import 12c Oracle Dump to 11g Ora 28001 The Password Has Expired Error Cache and Nocache in Oracle Sequence BR*Tools Documentation ORA-01455: Converting Column Overflows Integer Datatype Oracle Wait Events Interview Questions Difference Between Primary, Secondary and Clustered Indexes in DBMS Difference Between Hot and Cold Backup Oracle Partitioning Interview Questions Update Statement Works in Oracle Architecture Differences Between SAP HANA and Oracle Group Functions Ignore Null Values in Processed Column ORA-10458: Standby Database Requires Recovery Oracle Interview Questions

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.