Oracle Database Discussions

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!

Procedure hangs while create or replace!

misterimranJan 10 2013 — edited Jan 10 2013

Dear All,

My Database is Oracle 11g RAC.

I did few changes in one of my procedure and wanted to re-create it using CREATE OR REPLACE procedure...

The statement hangs for a long time and the concurrency in OEM raises up to a very high level. I tried to find the blocking sessions but for some time there was no blocking session.

I also tried stopping the activities on the tables used in this procedure.

Kindly suggest me what should I do in this situation. I have also tried running the query directly from the server.

Regards, Imran

This post has been answered by moreajays on Jan 10 2013

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 7 2013

Added on Jan 10 2013

#general-database-discussions

5 comments

1,224 views