chained rows

• Hi all,

Our monitoring tool reports that there are chained rows in the database. We analyze the schema once a week and get no rows returned from:

select owner, table_name, chain_cnt/num_rows*100 "chain%" from dba_tables
where num_rows <> 0 and chain_cnt <> 0;

The tech person from the monitoring tool's company told us that they determined chained rows by 'select value from v$sysstat where name ='table fetch continued row';

We do have a value returned from that query:

VALUE

     24132

My question is: how to find out which table has the chained row?

TIA
Robin

• Robin Li *
• Technical Specialist, DBA Phone#: (212) 297-3073 *
• FCG Management Services Fax#: (212) 297-4231 *
• 333 East 38th Street, 2nd fl. E-mail: rli_at_nyp.org *
• New York, NY 10016 *

  ---