How about tailredo?

    I have thinking what Oracle doing for a long time, since Oracle records all changes to the online redo logs, could we write a software just like "tail -f filenmae" command in Unix/Linux to view what are wroten to online log file in a realtime manner. After got this idea, I began to write an software called "tailredo". About one year ago, I had spent some time on online log format research, and wrote a too to dump each piece of redo log. Based on this utility, I made a first step quickly, following is an example of the "tailredo" output.

tailredo bo=big file=oracle_v8_log.log b1=20000 b2=20005 Sequence=34238, blocks=409600, dbid=938022666=0x37e9170a, grp#=1

0x000085be.00004e20.00fc 2006-05-03 15:30:10

[04.01] [Trans Block] Block Cleanout

0x000085be.00004e20.0138 2006-05-03 15:30:10

[05.01] [Trans Undo ] Undo block or under segment header -
KTURDB
[10.04] [Index ] Mark leaf row deleted

0x000085be.00004e21.00d8 2006-05-03 15:30:10

[04.01] [Trans Block] Block Cleanout

0x000085be.00004e21.0114 2006-05-03 15:30:10

[05.01] [Trans Undo ] Undo block or under segment header -
KTURDB
[10.04] [Index ] Mark leaf row deleted

0x000085be.00004e22.00b4 2006-05-03 15:30:10

[04.01] [Trans Block] Block Cleanout

0x000085be.00004e22.00f0 2006-05-03 15:30:10

[05.01] [Trans Undo ] Undo block or under segment header -
KTURDB
[10.04] [Index ] Mark leaf row deleted

0x000085be.00004e23.0090 2006-05-03 15:30:10

[04.01] [Trans Block] Block Cleanout

0x000085be.00004e23.00cc 2006-05-03 15:30:10

[05.01] [Trans Undo ] Undo block or under segment header -
KTURDB
[10.04] [Index ] Mark leaf row deleted

0x000085be.00004e24.007c 2006-05-03 15:30:10

[04.01] [Trans Block] Block Cleanout

0x000085be.00004e24.00b8 2006-05-03 15:30:10

[05.01] [Trans Undo ] Undo block or under segment header -
KTURDB
[10.04] [Index ] Mark leaf row deleted

0x000085be.00004e25.0058 2006-05-03 15:30:10

[04.01] [Trans Block] Block Cleanout

0x000085be.00004e25.0094 2006-05-03 15:30:10

[05.01] [Trans Undo ] Undo block or under segment header -
KTURDB
[10.04] [Index ] Mark leaf row deleted

    It could take me about half year time to make this utility meaningful, if someone want to take a test of this utility, send mail to me. This utility currently does not support 10g log file, because there is some big change in log format since 10g version.

AnySQL.net