Get the user_name from V$LOCKED_OBJECT, and get the SID and Serial# for that
user from V$SESSION, and kill that session. See if this helps.

Ram Srinivasan
PRA International, Inc.
4105 Lewis & Clark Drive
Charlottesville, VA 22911-5801
Tel: (434) 951-3365
Web: www.praintl.com


-----Original Message-----
From: Harmon, David [mailto:[Email Address Removed] Thursday, February 28, 2002 9:25 AM
To: LazyDBA.com Discussion
Subject: Timeout on drop procedure


I have a stored procedure that I'd like to drop. Using TOAD, whenever I try
to drop it, I get ORA-04021 - timeout occurred while waiting to lock
object.

I understand what the error message means, but how do I remove any locks on
that object, or override them and drop the object by brute force?

Thanks in advance!

--------
Oracle documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] the list archive: http://www.LAZYDBA.com/odbareadmail.pl
Tell yer mates about http://www.farAwayJobs.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
Oracle LazyDBA home page