onstat -g ckp - conv/rev ???
Posted in 2010
Hi people, What's the trigger Conv/Rev mean? This occur into a production environment... AUTO_CKPTS=On RTO_SERVER_RESTART=1800 seconds Estimated recovery time 57 seconds 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 4407 10:31:35 Startup 97674:0x39d5018 0.6 0.5 0.0 0 0.0 0.0 0.0 59 59 105 1 1 0 4408 10:35:02 *User 97674:0x510d018 0.6 0.1 0.0 9 0.4 0.4 0.6 375 375 8621 41 5944 28 4409 18:38:06 *CDR 97713:0x32de018 11.7 0.7 0.0 29 0.1 7.4 11.7 7572 7572 1250774 43 967270 33 4410 22:18:34 *Backup 97720:0xc39018 36.6 36.4 0.0 0 0.0 0.0 0.0 123316 3388 208923 15 165107 12 4411 15:40:34 *Conv/Rev 97818:0x1de2018 13.1 1.1 0.0 110 0.3 9.6 13.1 11294 10532 1676190 26 1509509 24 Max Plog Max Llog Max Dskflush Avg Dskflush Avg Dirty Blocked pages/sec pages/sec Time pages/sec pages/sec Time 1277 722 36 4384 1 0