| Azaz |
Posted: Jun 08, 2008 01:52:45 AM |
Total Post: 84
Joined: Mar, 2008
|
ORA-04021: timeout occurred while waiting to lock object
How can one resolve the said error |
|
|
Gitesh |
| Posted: Jun 09, 2008 11:07:10 PM | |
|
Total Post: 322
Joined: May, 2005
|
use dbms_lock.sleep(seconds). and execute again.
|
|
|
|
|
positive |
| Posted: Jun 26, 2008 03:40:30 PM | |
|
Total Post: 483
Joined: Jun, 2008
|
Use the SQL statement with WAIT clause .
|
|
|
|
|
Avnish |
| Posted: Jul 15, 2008 03:37:49 AM | |
|
Total Post: 154
Joined: Dec, 2007
|
Check what is holding the lock. look in the v$lock view. Columns of sid, type, lmode,request
or find through this query.
select oracle_username, os_user_name,locked_mode,object_name,object_type
from v$locked_object a, dba_objects b
where a.object_id=b.object_id
Thanks & Regards
Avnish Yadav
|
|
|
|
|
positive |
| Posted: Aug 11, 2008 08:48:45 PM | |
|
Total Post: 483
Joined: Jun, 2008
|
http://neworacledba.blogspot.com
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |