Re: Objects with blocks inside undo

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Wed, 22 Jun 2005 17:17:06 +0000 (UTC)
Message-ID: <d9c6ei$h25$1@nwrdmz03.dmz.ncs.ea.ibs-infra.bt.com>

"JLchiappa" <blaublau67-grupos_at_yahoo.com.br> wrote in message news:1119457975.231619.302700_at_o13g2000cwo.googlegroups.com...

Mladen, my desire is exactly to find which objects (and what lines of the tables/indexes, if possible) are protected by the given undo seg : yes, I was thinking in the line of dumping, reallly. I will visit JD´s site, but I have just one more question : afaik dumping will give me an image of the data , not the name of the tables/indexes where the data comes, right ?

Regards,

 Chiappa

Probably totally unreadable, but cut and paste into notepad or vi to get to fixed font, then check out record 9 in the block:

alter system dump datafile 2 block 144;

Start dump data blocks tsn: 1 file#: 2 minblk 144 maxblk 144 buffer tsn: 1 rdba: 0x00800090 (2/144)
scn: 0x0000.0675d214 seq: 0x01 flg: 0x00 tail: 0xd2140201 frmt: 0x02 chkval: 0x0000 type: 0x02=KTU UNDO BLOCK

---

UNDO BLK:

xid: 0x0009.029.00016a1e seq: 0x8f3 cnt: 0x9 irb: 0x9 icl: 0x0 flg: 0x0000
-----^^^^^^^^^^^^^^^^^^^ transaction id of last transaction to use this undo 

block

------------------------------------------^^^ number of records used.

Rec Offset Rec Offset Rec Offset Rec Offset Rec Offset

---

0x01 0x1f44 0x02 0x1ea0 0x03 0x1dfc 0x04 0x1d58 0x05 0x1cb4

0x06 0x1c10 0x07 0x1b6c 0x08 0x1b00 0x09 0x1aa4
------------------------------------------------^^^^^^^^^^^ Identifies start 

of record 9

{{ records 1 to 8 removed ))
*-----------------------------

* Rec #0x9 slt: 0x29 objn: 39277(0x0000996d) objd: 39288 tblspc:

9(0x00000009)
-----------------------------^^^^^ object_id of object changed
------------------------------------------------------^^^^^ data_object_id

• Layer: 11 (Row) opc: 1 rci 0x08 Undo type: Regular undo Last buffer split: No Temp Object: No Tablespace Undo: No rdba: 0x00000000
  *-----------------------------
  KDO undo record: KTB Redo op: 0x02 ver: 0x01 op: C uba: 0x00800090.08f3.08 ------------^^^^^^^^^^^^^^^^^^ address of previous undo record for this transaction KDO Op code: URP row dependencies Disabled -------------^^^ Operation, update row piece xtype: XA bdba: 0x02411e0a hdba: 0x02411e09 -------------------^^^^^^^^^^ address of block changed -------------------------------------^^^^^^^^^^ address of segment header for block changed itli: 2 ispac: 0 maxfr: 4863 tabn: 0 slot: 0(0x0) flag: 0x2c lock: 2 ckix: 0 ------^ table number within block (allows for clusters) --------------^^^^^ row number within block

ncol: 3 nnew: 1 size: -2
------^ number of columns in row
--------------^ number of columns changed col 2: [ 8] 79 79 79 79 79 79 79 79
-----^ column number of column changed.
End dump data blocks tsn: 1 file#: 2 minblk 144 maxblk 144

-- 
Regards

Jonathan Lewis

http://www.jlcomp.demon.co.uk/faq/ind_faq.html
The Co-operative Oracle Users' FAQ

http://www.jlcomp.demon.co.uk/seminar.html
Public Appearances - schedule updated April 5th 2005 

Received on Wed Jun 22 2005 - 12:17:06 CDT