ora04021:timeout occurred while waiting to lock object ...
From: tracy <tracykim10_at_yahoo.com.hk>
Date: 1 Apr 2004 00:29:28 -0800
Message-ID: <5c91cce9.0404010029.6b29baad_at_posting.google.com>
-------- -------- --------- -- --------- --------- --------- ---------
--------- ---------
-------- -------- --------- -- --------- --------- --------- ---------
--------- ---------
Date: 1 Apr 2004 00:29:28 -0800
Message-ID: <5c91cce9.0404010029.6b29baad_at_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
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
Received on Thu Apr 01 2004 - 10:29:28 CEST