There is a metalink document 169139.1 which discusses how to analyze
ora-4021 errors

Hans

-----Original Message-----
From: Gary Colbran (RDB Consulting)
[mailto:oracledba-ezmlmshield-x342146.[Email address protected]
Sent: woensdag 31 mei 2006 14:26
To: LazyDBA Discussion
Subject: Timeout waiting for lock


I have a package, and each time I try to replace it I get ora 4021
timeout, but there is no lock on the package. Can anyone tell me how to
find what is locking the package?

Disclaimer
This e-mail and any attachments transmitted with it are confidential and
intended solely for the use of the individual or entity to whom it is
addressed. If you have received this e-mail in error please notify the
sender and delete the original message. Any views or opinion expressed
in this e-mail are those of the author and do not necessarily represent
those of the Department of Labour. The recipient should check this
e-mail and any attachments for the presence of viruses and other
destructive codes. While all possible precautions have been taken, the
Department accepts no liability whatsoever for loss or damage resulting
from the opening of this message or attachments, or the use of the
information contained in this message or attachment.



--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
-----------------------------------------------------------------
ATTENTION:
The information in this electronic mail message is private and
confidential, and only intended for the addressee. Should you
receive this message by mistake, you are hereby notified that
any disclosure, reproduction, distribution or use of this
message is strictly prohibited. Please inform the sender by
reply transmission and delete the message without copying or
opening it.

Messages and attachments are scanned for all viruses known.
If this message contains password-protected attachments, the
files have NOT been scanned for viruses by the ING mail domain.
Always scan attachments before opening them.
-----------------------------------------------------------------


Oracle LazyDBA home page