Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

UTLRP.SQL run very long, how to check ?

768546Apr 23 2010 — edited Apr 24 2010
Hello all

Need your help and advice on my problem that i facing now,
I did to recompile all the object in oracle using

@UTLRP.SQL in $ORACLE_HOME\rdbms\admin

The sql was running about 4 hours but still running, but actually i dont know is it hang or still running

My question is
- is this normal, since that already run for 4 hours
- how to check whether is still running or hang, I did check on the task manager, the oracle.exe keep moving
- Can i cancell it ? any problem later on if i cancel it ?
- Is there any log to check

Sorry so many question, need all of your advice

Thanks in advance

Cheers
Surya
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 22 2010
Added on Apr 23 2010
4 comments
6,165 views