onstat -g ckp - conv/rev ??? -
10-05-2010
, 01:55 PM
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********** * |