Oracle Database Discussions

Hi All,

We have an strange situation where ckpt process of both the nodes are involving in blocker and blocked operation as shown below.

SQL> select inst_id, handle, grant_level, request_level, resource_name1, resource_name2, pid , transaction_id0, transaction_id1
 ,owner_node, blocked, blocker, state from gv$ges_blocking_enqueue;

   INST_ID HANDLE           GRANT_LEV REQUEST_L RESOURCE_NAME1                 RESOURCE_NAME2                        PID
---------- ---------------- --------- --------- ------------------------------ ------------------------------ ----------
TRANSACTION_ID0 TRANSACTION_ID1 OWNER_NODE    BLOCKED    BLOCKER STATE
--------------- --------------- ---------- ---------- ---------- ------------------------------
         2 000000057CADE778 KJUSERNL  KJUSEREX  [0x19][0x2],[RS]               25,2,RS                             17610
              0               0          1          1          0 OPENING

         1 000000057CADE778 KJUSEREX  KJUSEREX  [0x19][0x2],[RS]               25,2,RS                             11670
              0               0          0          0          1 GRANTED


SQL> !ps -ef|grep 11670
  oracle 29878 15945   0 06:33:44 pts/2       0:00 grep 11670
  oracle 11670     1   0   Aug 25 ?         506:02 ora_ckpt_dealsdb1


SQL> !uname -a
NODE1

From second node:
SQL> !ps -ef|grep 17610
  oracle 23160 22632   0 06:35:26 pts/1       0:00 grep 17610
  oracle 17610     1   0   Aug 25 ?         546:14 ora_ckpt_dealsdb2

SQL> !uname -a
NODE2

Quiet confused as why both the blocker and blocked process are ckpt process..

SQL> select INST_ID,GRANT_LEVEL,REQUEST_LEVEL,PID,STATE,BLOCKED,BLOCKER from gv$ges_enqueue where BLOCKED > 0;

   INST_ID GRANT_LEV REQUEST_L        PID STATE                             BLOCKED    BLOCKER
---------- --------- --------- ---------- ------------------------------ ---------- ----------
         2 KJUSERNL  KJUSEREX       17610 OPENING                                 1          0


SQL> select INST_ID,GRANT_LEVEL,REQUEST_LEVEL,PID,STATE,BLOCKED,BLOCKER from gv$ges_enqueue where BLOCKER > 0;
   INST_ID GRANT_LEV REQUEST_L        PID STATE                             BLOCKED    BLOCKER
---------- --------- --------- ---------- ------------------------------ ---------- ----------
         1 KJUSEREX  KJUSEREX       11670 GRANTED                                 0          1

Could anyone please assist on this problem....else i think its normal behaviour as Checkpoint can be performed by only node ckpt process..

-Yasser

Environment details:
Two node Oracle 10g 10.2.0.3.0 RAC
SunOS 5.10 Generic_125100-10 sun4u sparc SUNW,SPARC-Enterprise