OraFAQ Forum: Server Administration » ORA-04021 Timeout error while waiting to lock the object

Home » RDBMS Server » Server Administration » ORA-04021 Timeout error while waiting to lock the object

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-04021 Timeout error while waiting to lock the object [message #57937]

Mon, 21 July 2003 08:20

Praveen Kumar
Messages: 21
Registered: December 2001

Junior Member

I am working on Oracle Forms9i. After every compilation and execution of the form it locks the referred procedure/view inside for some period. During this period it does not allow to modify the procedure/view. While trying so it gives following error message after 3-4 minutes of issuing the create or replace command.

*** Error message *****
ORA-04021: timeout occurred while waiting to lock object SECURITY.USER_MENU1

Can you suggest how to get rid of this problem.

Thanks,

Report message to a moderator

Re: ORA-04021 Timeout error while waiting to lock the object [message #57941 is a reply to message #57937]

Mon, 21 July 2003 11:55

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

seems like an LC lock.
query the v$access to see which user is causing the lock.
Make sure ur code is not affecting the objects / blocks u are currently accessing and being dependent on

dbadmin@mutation_mutation > desc v$access
 Name                                                  Null?    Type
 ----------------------------------------------------- -------- ------------------------------------
 SID                                                            NUMBER
 OWNER                                                          VARCHAR2(64)
 OBJECT                                                         VARCHAR2(1000)
 TYPE                                                           VARCHAR2(24)

dbadmin@mutation_mutation >

Report message to a moderator

Previous Topic:	Drop table
Next Topic:	Oracle Initialization or Shutdown in Progress

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jan 02 15:11:36 CST 2025