Re: question about redo size in logminer and view Options
From: lsllcm <lsllcm_at_gmail.com>
Date: Sun, 26 Jul 2009 01:35:26 -0700 (PDT)
Message-ID: <383e9e5b-8d51-4678-b189-b149e8148c10_at_o9g2000prg.googlegroups.com>
After test again, the result is same
Date: Sun, 26 Jul 2009 01:35:26 -0700 (PDT)
Message-ID: <383e9e5b-8d51-4678-b189-b149e8148c10_at_o9g2000prg.googlegroups.com>
After test again, the result is same
Below are data
--from view
redo size: 3456 - 2812 = 644
redo waste: 60839820 - 60839472 = 348
--from contents
RBA 2: 512 - 16 = 496
RBA 3: 68 + 80 = 148
Total size: 496 + 148 = 644
--from trace file
RBA 2: 0x0224 = 548
RBA 3: 0x0060 = 96
Total size: 548 + 96 = 644
--get commit from waste
992 (2 * RBA block size) - 496 (RBA 2) - 68 (RBA 3) - 348 (Waste size)
= 80
Received on Sun Jul 26 2009 - 03:35:26 CDT