RE: Row Migration/Rowchaining

From: <>
Date: Tue, 15 Apr 2008 05:19:27 -0400
Message-ID: <>

They've gone thru a couple of iterations at various places i've worked, you're right they are out of date compared to the latest versions of oracle but I can put them up on a site if someone wants them.


You can have it: Fast, Right or Cheap, pick 2 of the 3. Fast + Right is Expensive
Fast + Cheap will be incorrect.
Right + Cheap will take a while.

"John Hallas" <>

Sent by:

04/15/2008 04:56 AM
Please respond to

"John Hallas" <>

<>, <> cc
RE: Row Migration/Rowchaining

You need to analyze tables and list chained rows. @utlchain I believe that oracle does not discriminate between a chained and migrated row even though they have different causes  

In fact Metalink Note 102989.1 indicates that the resolution is the same for both types identify the rows, copy the chained rows out to anew table, delete them from the original table and then move them back again.    

PS, not worth a separate post but I wrote an article about log shipping (dataguard, streams etc) on my blog site and discovered it had been linked to a Forklift Truck site today. Obviously shipping was the key word.  

PPS, Joe do you still have your RMAN scripts online. They used to be a good resource. Probably a bit out of date now though.  

From: [] On Behalf Of
Sent: 11 April 2008 19:54
Subject: Re: Row Migration/Rowchaining  

This will show you the table for chained rows, not sure if it covers migrated or not, anyone else?

 select owner, table_name, chain_cnt from dba_tables where chain_cnt > 0;



Please do not transmit orders or instructions regarding a UBS account by e-mail. The information provided in this e-mail or any attachments is not an official transaction confirmation or account statement. For your protection, do not include account numbers, Social Security numbers, credit card numbers, passwords or other non-public information in your e-mail. Because the information contained in this message may be privileged, confidential, proprietary or otherwise protected from disclosure, please notify us immediately by replying to this message and deleting it from your computer if you have received this communication in error. Thank you.

UBS Financial Services Inc.

UBS International Inc.

UBS Financial Services Incorporated of Puerto Rico --

The information included in this email and any files transmitted with it may contain information that is confidential and it must not be used by, or its contents or attachments copied or disclosed, to persons other than the intended addressee. If you have received this email in error, please notify BJSS.
In the absence of written agreement to the contrary BJSS’ relevant standard terms of contract for any work to be undertaken will apply. Please carry out virus or such other checks as you consider appropriate in respect of this email. BJSS do not accept responsibility for any adverse effect upon your system or data in relation to this email or any files transmitted with it.
BJSS Limited, a company registered in England and Wales (Company Number 2777575), VAT Registration Number 613295452, Registered Office Address, First Floor, Coronet House, Queen Street, Leeds, LS1 2TW

Received on Tue Apr 15 2008 - 04:19:27 CDT

Original text of this message