RE: Row Migration/Rowchaining
- From: TESTAJ3@xxxxxxxxxxxxxx
- To: john.hallas@xxxxxxxxxx
- Date: Tue, 15 Apr 2008 05:19:27 -0400
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@xxxxxxxxxx>
Sent by: oracle-l-bounce@xxxxxxxxxxxxx
04/15/2008 04:56 AM
Please respond to john.hallas@xxxxxxxxxx
From
"John Hallas" <john.hallas@xxxxxxxxxx>
To
<TESTAJ3@xxxxxxxxxxxxxx>, <maheswara.rao@xxxxxxx>
cc
<oracle-l@xxxxxxxxxxxxx>
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.
http://jhdba.wordpress.com/
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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of TESTAJ3@xxxxxxxxxxxxxx
Sent: 11 April 2008 19:54
To: maheswara.rao@xxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
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
--
//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
Other related posts: