6 Replies Latest reply: Dec 3, 2012 1:57 AM by Osama_Mustafa RSS

    CKPT locks the system objects and blocks other sessions

    968135
      CKPT locks the system objects and blocks other sessions
      Oracle Version 10.2.0.4
      OS : HP UX 11.31 Itanium

      SQL> select * from v$lock where block=1;

      ADDR KADDR SID TY ID1 ID2 LMODE
      ---------------- ---------------- ---------- -- ---------- ---------- ----------
      REQUEST CTIME BLOCK
      ---------- ---------- ----------
      C0000009FCC2B348 C0000009FCC2B368 1100 RO 65559 1 2
      0 3877 1


      SQL> select program from v$session where sid=1100;

      PROGRAM
      ------------------------------------------------
      oracle@ctqanhr1 (CKPT)


      As a workaround we flush the buffer cache with the below command
      SQL> alter system flush buffer_cache;

      however the issue reoccurs after some times.

      Edited by: 965132 on Dec 2, 2012 9:59 PM