This discussion is archived
6 Replies Latest reply: Dec 2, 2012 11:53 PM by Samuel G. Cristobal RSS

CKPT locks the system objects and blocks other sessions

968135 Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points