Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.oracle -> ora04021:timeout occurred while waiting to lock object ...

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@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 - 02:29:28 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US