Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Where do you find undo info in trace files, and how
Juan:
Here is the sample. It is an undo block dump. Are you looking for block dumps or undo traces?
*-----------------------------
* Rec #0x1 slt: 0x2d objn: 31961(0x00007cd9) objd: 31961 tblspc:
14(0x000000
0e)
* Layer: 11 (Row) opc: 1 rci 0x00
Undo type: Regular undo Begin trans Last buffer split: No
Temp Object: No
Tablespace Undo: No
rdba: 0x00000000
*-----------------------------
uba: 0x03401ea9.0247.12 ctl max scn: 0x0000.004f0664 prv tx scn:
0x0000.004f06eb
KDO undo record:
KTB Redo
op: 0x04 ver: 0x01
op: L itl: xid: 0x0034.008.0000088a uba: 0x034546ec.027f.03
flg: C--- lkc: 0 scn: 0x0000.004ef173KDO Op code: QMD row dependencies Disabled xtype: XA bdba: 0x03875321 hdba: 0x0382059a itli: 2 ispac: 0 maxfr: 3239
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Sep 29 2004 - 02:30:42 CDT
![]() |
![]() |