Re: chained rows

I am working on some tables similar. You may not have chained rows at all. You may have migrated rows. In reading Oracle documentation on analyzing tables and what the CHAIN_CNT column in DBA_TABLES, it states that the CHAIN_CNT column contains a count of all chained and migrated rows. Also note that you could have multiple migrations.

Hope this helps.

Tx
Eric Peterson
Programmer/Analyst DBA
Maurices Inc.
eric_peterson_at_maurices.inrg.com

In article <7m01be$i9u$1_at_nnrp1.deja.com>,   farrellyr_at_my-deja.com wrote:
> I have done the dbms_utility.analyze_schema and have come up with a
few
> tables that have chain_cnt > 5 in the dba_tables. When I look in the
> chained_row table I don't have any information there, no head_rowid in
> order to delete and re-insert the rows. I have used the analyze table
> 'table_name' list chained rows and compute statistics, but I still
> don't have anything show up when I query the chained_rows table. Does
> this mean chaining isn't a problem? Should there be some rows showing
> up in the chained_rows table to correspond with the dba_tables? Or am
> I doing something wrong?
>
> Thanks again.
>
> In article <9NFg3.4397$nw2.1038_at_newreader.ukcore.bt.net>,
> "Kevin A Lewis" <KevinALewis_at_Hotmail.com> wrote:
> > 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.
> >
> >
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Fri Jul 09 1999 - 11:23:56 CDT