Expand all | Collapse all

Blocking Checkpoint?

  • 1.  Blocking Checkpoint?

    Posted 11 days ago
    Ifmx 12.10.FC14
    Solaris 10 1/13

    What does it mean when a checkpoint shows "# Waits" = 1, but "Block Time", "Ckpt Time", "Wait Time", "Long Time" are all zero?

                                                                                                                Critical Sections                                 Physical Log   Logical Log
                   Clock                                                      Total  Flush Block  #      Ckpt  Wait  Long  # Dirty  Dskflu  Total     Avg    Total     Avg
    Interval    Time       Trigger              LSN                Time  Time  Time  Waits Time Time Time   Buffers  /Sec   Pages   /Sec   Pages   /Sec

    880488 13:44:00 CKPTINTVL 51521:0x1776018   0.5     0.5    0.0    1       0.0    0.0   0.0    19381   19381  13099   21      24250   40​​

    Thank you.


    David Grove

  • 2.  RE: Blocking Checkpoint?

    Posted 11 days ago
    This would mean that there was a single session that had to wait before entering a critical section for the checkpoint to happen.  It waited less than 0.1 seconds, otherwise you would see the wait time be > 0.  With such a short wait, it's unlikely to be a problem.

    Mike Walker

  • 3.  RE: Blocking Checkpoint?

    Posted 11 days ago
    It means that one session experienced a block that lasted less than 0.5sec during that checkpoint.


    Art S. Kagel, President and Principal Consultant
    ASK Database Management Corp.