Enqueue wait event on I_OBJ# and C_OBJ#

From: <dba.orcl_at_gmail.com>
Date: 24 Dec 2005 07:09:40 -0800
Message-ID: <1135436980.752241.313420@g44g2000cwa.googlegroups.com>

While we are updating one of the application table with high number of concurrency(update) we started seeing
TX wait on I_OBJ# and C_OBJ# (object id 2 and 3) as below.

select * from gv$lock where request !=0;

   INST_ID      SID TY        ID1        ID2      LMODE    REQUEST
CTIME      BLOCK

---------- -------- -- ---------- ---------- ---------- ----------
---------- ----------

         1       50 TX    2424846          2          0          6
  519          0
         1      116 TX    7733248          2          0          6
    4          0
         1       24 TX    7667720          3          0          6
   16          0
         1      110 TX    7798790          3          0          6
    5          0

The above locks are increased by increasing the number of concurrency.

SQL> select id2,count(*) from gv$lock where lmode=6 and id2 in (2,3) group by id2;

       ID2 COUNT(*)
---------- ----------

         2        132
         3        132

132, is it a limit to acquire number of TX locks on I_OBJ# and C_OBJ#?

Thanks in advance.
Sami Received on Sat Dec 24 2005 - 09:09:40 CST