RE: Row Migration/Rowchaining
Date: Tue, 15 Apr 2008 05:19:27 -0400
Message-ID: <OFAE3D7D74.542759F5-ON8525742C.00330B8E-8525742C.00333872@lnotes-gw.ent.nwie.net>
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.
joe
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" <john.hallas_at_bjss.co.uk>
Sent by: oracle-l-bounce_at_freelists.org
04/15/2008 04:56 AM
Please respond to john.hallas_at_bjss.co.uk
From
"John Hallas" <john.hallas_at_bjss.co.uk>
To
<TESTAJ3_at_nationwide.com>, <maheswara.rao_at_ubs.com>
cc
<oracle-l_at_freelists.org>
Subject
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: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]
On Behalf Of TESTAJ3_at_nationwide.com
Sent: 11 April 2008 19:54
To: maheswara.rao_at_ubs.com
Cc: oracle-l_at_freelists.org
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;
joe
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
--
http://www.freelists.org/webpage/oracle-l
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
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Apr 15 2008 - 04:19:27 CDT