CKPT locks the system objects and blocks other sessions
968135Dec 3 2012 — edited Dec 3 2012CKPT 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