Hi,

I ran UTLBSTAT/ESTAT and in table fetch continued row i found 33000+ rows. This means chained rows/migrated rows.

Now I need to identify the tables with can probebly hv chained rows. I hv 20,000+ tables in my application (SAP)

What I hv done is that i hv taken a list of following fields form dba_tables

TABLE_NAME
PCT_FREE
PCT_USED
FREELISTS
NUM_ROWS
BLOCKS
AVG_ROW_LEN

I guess with the help of these I can shortlist further some tables on which i can run analyze table.... list chained rows to get the rows.

Can I use the above info. Eg for two table values are as below :


D010L
10
40
1
74632
224296
8076

VRSMODISRC
10
40
1
218
81
2322


Any Ideas ??

Vijay