Re: Incorrect Migrated/Chained rows...

From: MAK <maks70_at_comcast.net>
Date: 29 Apr 2004 10:50:46 -0700
Message-ID: <b7178504.0404290950.31e5ecd4@posting.google.com>

>
> Suggested experiment:
> create some 300 column rows that are only 1,000 bytes long.
> See if Oracle will allow the two pieces to be in different blocks
> See if they are reported as chained when
> a) the two pieces are in the same block
> b) the two pieces are in different blocks.
>
> There's a recent article about row-chaining here that might
> be of interest.
> http://www.tlingua.com/articles/rc.html

JL,

Thanks for your valuable feed-back. How do I check wheather two row pieces are in the same or different block? I presume you must be refering to block dump. Right.
I have question regarding dumping block that has migrated/chained row. I got the row id & its extended rowid as well. see following.

1 select dbms_rowid.rowid_to_restricted(rowid,0)   2 from mars7.TEMP_S_CONTACT_02
  3 where rowid in (select head_rowid
  4 from mars7.chained_rows
  5 where table_name = 'TEMP_S_CONTACT_02'   6* )
AC7MARS.SYS.SQL>
/

DBMS_ROWID.ROWID_T

00099BF0.001A.0044
-Blk#---.-RID-.File#.

What value I should be supplying to for the block no? Should I supply decimal of 99BF0(629744)?

alter system dump datafile 44 block <blk#>

Infact I supplied that but did not gave good dump. In header it self says following.

Start dump data blocks tsn: 22 file#: 44 minblk 629744 maxblk 629744 buffer tsn: 22 rdba: 0x00099bf0 (0/629744) scn: 0x0000.00000000 seq: 0x01 flg: 0x01 tail: 0x00000001 frmt: 0x02 chkval: 0x0000 type: 0x00=unknown Hex dump of corrupt header 4 = CORRUPT

Thanks in advance for your help... Received on Thu Apr 29 2004 - 12:50:46 CDT