Link to home
Start Free TrialLog in
Avatar of koolsyed
koolsyed

asked on

ORA-04021: timeout occurred :: while Compiling a procedure

Hey Frnz..
I am trying to compile a procedure by command ALTER PROCEDURE MY_PROC COMPILE;
But everytime i do this, get the below error.
ORA-04021: timeout occurred while waiting to lock object MY_PROC.
When i tried for some solution thru google, just got suggestion to  run the command again..

Can someone help me in this regard ?
Avatar of divyeshhdoshi
divyeshhdoshi

your procedure may try to lock an object of database
but due to some restriction it cannot able to do this.
may this procedure is running while u compiling
Avatar of koolsyed

ASKER

no, this procedure is not running..i made some changes to it but not able to compile.
ASKER CERTIFIED SOLUTION
Avatar of Naveen Kumar
Naveen Kumar
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
by the way, what is your procedure trying to do ?

can u post the code of your procedure ?
Thanks for the loack check query...we had several locks from different developers.(sessions) i re-booted the server...issue got automatically resolved..the query will be helpful for me..hence points. If you have some good way of checking locks and resolving them would be of grt help to me! Ahmad