Re: Row Migration/Rowchaining

From: TESTAJ3@xxxxxxxxxxxxxx

To: maheswara.rao@xxxxxxx

Date: Fri, 11 Apr 2008 14:54:05 -0400

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
---------------------------------------
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.
maheswara.rao@xxxxxxx
Sent by: oracle-l-bounce@xxxxxxxxxxxxx
04/11/2008 02:40 PM
Please respond to maheswara.rao@xxxxxxx
From
maheswara.rao@xxxxxxx
To
<oracle-l@xxxxxxxxxxxxx>
cc
Subject
Row Migration/Rowchaining
In my database when I run the following query against v$sysstat, I find
huge number of migrated/chained rows.
SQL> SELECT name, value
FROM v$sysstat
WHERE name = 'table fetch continued row';
NAME VALUE
---------------------------------- --------
table fetch continued row 2327441
How do I find to which table these migrated/chained rows belong?
Please help.
Thanks,
Rao
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