ora04021:timeout occurred while waiting to lock object ...

[tracy]

hi,
when i run this sql,i got this error
SQL> grant all on raw_ptptn_data to unitem_role;
grant all on raw_ptptn_data to unitem_role
*
ERROR at line 1:
ORA-04021: timeout occurred while waiting to lock object
SHAHRUL.RAW_PTPTN_DATA

I try few times, but failed.

I had check my shared_pool_size and java_pool_size, 80 meg
respectively.

when i check v$lock, i got this:
SQL> select * from v$lock;

ADDR KADDR SID TY ID1 ID2 LMODE REQUEST
CTIME BLOCK
-------- -------- --------- -- --------- --------- --------- ---------
--------- ---------
5633A26C 5633A27C 2 MR 202 0 4 0
3317 0
5633A0A4 5633A0B4 2 MR 201 0 4 0
4753256 0
5633A058 5633A068 2 MR 18 0 4 0
4753256 0
5633A00C 5633A01C 2 MR 17 0 4 0
4753256 0
56339FC0 56339FD0 2 MR 16 0 4 0
4753256 0
56339F74 56339F84 2 MR 15 0 4 0
4753256 0
56339F28 56339F38 2 MR 14 0 4 0
4753256 0
56339EDC 56339EEC 2 MR 13 0 4 0
4753256 0
56339E90 56339EA0 2 MR 12 0 4 0
4753256 0
56339E44 56339E54 2 MR 11 0 4 0
4753256 0
56339DF8 56339E08 2 MR 10 0 4 0
4753256 0
56339DAC 56339DBC 2 MR 9 0 4 0
4753256 0
56339D60 56339D70 2 MR 8 0 4 0
4753256 0
56339D14 56339D24 2 MR 7 0 4 0
4753256 0
56339CC8 56339CD8 2 MR 6 0 4 0
4753256 0
56339C7C 56339C8C 2 MR 5 0 4 0
4753256 0
56339C30 56339C40 2 MR 4 0 4 0
4753256 0
56339BE4 56339BF4 2 MR 3 0 4 0
4753256 0
56339B98 56339BA8 2 MR 2 0 4 0
4753256 0
56339B4C 56339B5C 2 MR 1 0 4 0
4753256 0
56339A68 56339A78 3 RT 1 0 6 0
4753259 0

ADDR KADDR SID TY ID1 ID2 LMODE REQUEST
CTIME BLOCK
-------- -------- --------- -- --------- --------- --------- ---------
--------- ---------
56339938 56339948 4 XR 4 0 1 0
4753261 0
56339AB4 56339AC4 5 TS 2 1 3 0
4753253 0
I dun know how to read.

no row return from V$locked_object.
please advise!TQ
regards,
tracy

[Yong Huang]

tr********@yahoo.com.hk (tracy) wrote in message news:<5c**************************@posting.google. com>...

hi,
when i run this sql,i got this error
SQL> grant all on raw_ptptn_data to unitem_role;
grant all on raw_ptptn_data to unitem_role
*
ERROR at line 1:
ORA-04021: timeout occurred while waiting to lock object
SHAHRUL.RAW_PTPTN_DATA
...
no row return from V$locked_object.

Hi, tracy,

Check dba_ddl_locks or dba_lock_internal. Tom Kyte's book talks about
dba_ddl_locks. Or check x$kgllk. A look at v$session_wait for library
cache locks waits and matching the library object handle with
x$kglobj.KGLHDADR can also tell you the session that holds the locks.

v$lock and v$locked_object only shows enqueue locks, not library cache
locks.

If you post your message to comp.databases.oracle.server, you'll get
an answer faster.

Yong Huang