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.004ef173
KDO Op code: QMD row dependencies Disabled
  xtype: XA  bdba: 0x03875321  hdba: 0x0382059a
itli: 2  ispac: 0  maxfr: 3239
tabn: 0 lock: 0 nrow: 1
slot[0]: 34




=====
Have a nice day !!
------------------------------------------------------------
Best Regards,
K Gopalakrishnan,
Co-Author: Oracle Wait Interface: Oracle Press 2004.
http://www.amazon.com/exec/obidos/tg/detail/-/007222729X/


                
__________________________________
Do you Yahoo!?
Read only the mail you want - Yahoo! Mail SpamGuard.
http://promotions.yahoo.com/new_mail 
--
http://www.freelists.org/webpage/oracle-l

Other related posts: