example 1 - cheeyoung/sqlplus-public GitHub Wiki
...
101994
101995 REDO RECORD - Thread:1 RBA: 0x002a6e.00509a5a.0010 LEN: 0x0214 VLD: 0x01 CON_UID: 0
101996 SCN: 0x00000d688548ed6e SUBSCN: 37 12/13/2019 12:30:56
101997 CHANGE #1 CON_ID:0 TYP:0 CLS:161 AFN:10 DBA:0x02800358 OBJ:4294967295 SCN:0x00000d688548ed6e SEQ:2 OP:5.2 ENC:0 RBL:0 FLG:0x0000
101998 ktudh redo: slt: 0x001d sqn: 0x00000000 flg: 0x000a siz: 164 fbi: 128
101999 uba: 0x020ccfb6.1a64.01 pxid: 0x0000.000.00000000
102000 CHANGE #2 CON_ID:0 TYP:1 CLS:162 AFN:8 DBA:0x020ccfb6 OBJ:4294967295 SCN:0x00000d688548ed6e SEQ:1 OP:5.1 ENC:0 RBL:0 FLG:0x0000
102001 ktudb redo: siz: 164 spc: 46 flg: 0x000a seq: 0x1a64 rec: 0x01
102002 xid: 0x0049.01d.00020bcb
102003 ktubu redo: slt: 29 rci: 0 opc: 13.29 objn: 214748 objd: 283399 tsn: 40
102004 Undo type: Regular undo Undo type: Last buffer split: No
102005 Tablespace Undo: No
102006 0x020ccfb5
102007 Segment Header Undo
102008 Seghdr dba: 0x43406e11 Mapblock dba: 0x00000000 Mapredo Offset: 4 scls: 4 mcls: 140720308486151
102009 Both the HWMs
102010 Low HWM
102011 Highwater:: 0x4941be60 ext#: 15 blk#: 96 ext size: 96
102012 #blocks in seg. hdr's freelists: 0
102013 #blocks below: 14368
102014 mapblk 0x00000000 offset: 15
102015 lfdba: 0x4941be00
102016 High HWM
102017 Highwater:: 0x4941be60 ext#: 15 blk#: 96 ext size: 96
102018 #blocks in seg. hdr's freelists: 0
102019 #blocks below: 14368
102020 mapblk 0x00000000 offset: 15
102021 lfdba: 0x4941be00 hint dba: 0x43406e10
102022 Lasts in Header
102023 LF: 1229045248 LS: 1132477968 LT: 1132477969 FT: 1145168913
102024 CHANGE #3 CON_ID:0 TYP:0 CLS:4 AFN:269 DBA:0x43406e11 OBJ:283399 SCN:0x00000d688548ed6e SEQ:1 OP:13.28 ENC:0 RBL:0 FLG:0x0000
102025 Both the HWMs
102026 Low HWM
102027 Highwater:: 0x43406e12 ext#: 0 blk#: 18 ext size: 32
102028 #blocks in seg. hdr's freelists: 0
102029 #blocks below: 0
102030 mapblk 0x00000000 offset: 0
102031 lfdba: 0x43406e00
102032 High HWM
102033 Highwater:: 0x43406e12 ext#: 0 blk#: 18 ext size: 32
102034 #blocks in seg. hdr's freelists: 0
102035 #blocks below: 0
102036 mapblk 0x00000000 offset: 0
102037 lfdba: 0x43406e00 hint dba: 0x43406e10
102038 Lasts in Header
102039 LF: 1145168911 LS: 1145168912 LT: 1145168913 FT: 1145168913
102040 CHANGE #4 CON_ID:0 TYP:0 CLS:8 AFN:269 DBA:0x43406e00 OBJ:283399 SCN:0x00000d688548ed6e SEQ:2 OP:13.22 ENC:0 RBL:0 FLG:0x0000
102041 Redo on Level1 Bitmap Block
102042 Redo to set hwm
102043 Opcode: 32 Highwater:: 0x43406e12 ext#: 0 blk#: 18 ext size: 32
102044 #blocks in seg. hdr's freelists: 0
102045 #blocks below: 0
102046 mapblk 0x00000000 offset: 0
102047
...