Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: chained rows
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.
Received on Wed Jul 07 1999 - 12:04:57 CDT