Re: chained rows

The simplest way that I have found is to analyze statistics for a whole schema

execute sys.dbms_utility.analyze_schema('SCHEMA_NAME','estimate',null,'20')

This estimates the table to 20 % of its data content and this can be adjusted to suit your environment.

Then when complete statistics on the tables and indexes will exist in the administration views of the database. For instance DBA_TABLES.

If you query DBA_TABLES for CHAIN_CNT > 0 you will have most of the affected tables and an approximation of the extent of the chaining.

Regards

--
Kevin A Lewis (BOCM PAULS LTD - Animal Feed Manufacturer - Ipswich England)

                        <KevinALewis_at_HotMail.com>

The views expressed herein by the author of this document are not necessarily those of BOCM PAULS Ltd. <farrellyr_at_my-deja.com> wrote in message news:7ltrcu$pe8$1_at_nnrp1.deja.com...
> I want to start checking for chained rows. I have run the utlchain.sql
> to set up table for information. What I am wondering is, do I have to
> go through and analyze table 'table_name' list chained rows for every
> table? Or is there a way I can narrow it down to a certain number of
> tables? Like maybe finding the most used or something like that, if so
> how would I go about that?
>
> Thanks.
>
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
Received on Wed Jul 07 1999 - 05:21:09 CDT