Fast object checkpoint

From: Mladen Gogala <mgogala_at_verizon.net>
Date: Fri, 22 Sep 2006 20:02:52 -0400
Message-id: <1158969772l.2778l.2l@medo.noip.com>

What is a "fast object checkpoint"? I have script which has to update ~60M rows. I had to kill it and re-start it. The new incarnation did not wait for a bunch of TX locks, it was waiting for the following event:

ENQ: KO - fast object checkpoint

Surprisingly enough, this lock was held by the CKPT process, not PMON, as I've expected. Very few undo blocks were actually consumed in v$undostat. My question is what is "fast object checkpoint" and is there a new method of reclaiming resources held by murdered transactions? Is it documented anywhere?

--

Mladen Gogala
http://www.mgogala.com

--

http://www.freelists.org/webpage/oracle-l Received on Fri Sep 22 2006 - 19:02:52 CDT