question about redo size in logminer and view Options

I have one question about redo size in logminer and view Options

When I test redo size from logminer and view options, the results are different. Below is the test case.

Oracle verison
SQL*Plus: Release 11.1.0.6.0 - Production on Thursday July 23 22:45:14 2009

Copyright (c) 1982, 2007, Oracle. All rights reserved.

1. login as one user jacky/jacky and create table test drop table tt purge; create table tt ( tt_id number, tt_name varchar2(10));
2. insert records insert into tt values (1, 'TT1'); insert into tt values (2, 'TT2'); insert into tt values (3, 'TT3'); commit;
3. alter system switch logfile;
4. insert records insert into tt values (4, 'TT4'); commit;
5. alter system switch logfile;
6. get redo size from result: SELECT 'REDO START', n.name, s.value FROM v$sesstat s, v$statname n WHERE s.statistic# = n.statistic# AND n.name = 'redo size' and s.sid = (select sid from v$session where username = 'JACKY');

   ---

   before: 6348 end: 7036 The redo size: 688
7. run logminer

EXECUTE DBMS_LOGMNR_D.BUILD('dictionary.ora', 'C:\APP\LCM\ORADATA\ORCL \', DBMS_LOGMNR_D.STORE_IN_FLAT_FILE); begin
dbms_logmnr.add_logfile(
options => dbms_logmnr.addfile,
logfilename=>'C:\APP\LCM\ORADATA\ORCL\REDO03.LOG'); end;
/

begin
dbms_logmnr.start_logmnr(
dictfilename=>'C:\APP\LCM\ORADATA\ORCL\dictionary.ora' );
end;
/

check contents

select * from v$logmnr_contents ;

RBABLK RBABYTE SQL REDO

    8               16           set transaction read write;
    8               16           insert into
"JACKY"."TT"("TT_ID","TT_NAME") values ('3','TT3');
    9               64           commit;

RBABLK 8: 512 (one block size) - 16 (block header size) = 496 bytes RBABLK 9: 80 (commit size) + 64 - 16 (block header size) = 128 bytes

Total size: 496 + 128 = 624 bytes

Thanks at first
Jacky Received on Thu Jul 23 2009 - 09:49:26 CDT