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 Received on Fri Apr 11 2008 - 13:40:53 CDT