Xref: alice comp.databases.oracle.server:20309
Path: alice!news-feed.fnsi.net!news.idt.net!newshub.northeast.verio.net!cpk-news-hub1.bbnplanet.com!news.bbnplanet.com!news.maxwell.syr.edu!nntp2.dejanews.com!nnrp1.dejanews.com!not-for-mail
From: bialik@wis.weizmann.ac.il
Newsgroups: comp.databases.oracle.server
Subject: Re: Chained fetch ratio
Date: Tue, 05 May 1998 15:12:34 -0600
Organization: Deja News - The Leader in Internet Discussion
Lines: 46
Message-ID: <6inrri$cqf$1@nnrp1.dejanews.com>
References: <354F2F3A.87C00EF9@microware.demon.co.uk>#1/1
X-Article-Creation-Date: Tue May 05 20:12:34 1998 GMT
X-Http-User-Agent: Mozilla/4.04 [en] (Win95; I)
X-Http-Proxy: 1.0 wisweb.weizmann.ac.il:8080 (Squid/1.1.17), 1.0 wwwproxy1.ac.il:8080 (Squid/1.1.20) for client 132.76.33.136, 132.76.33.15

Hi.

Probably, you didn't analyze your tables.
The chained-rows stats are collected by :
ANALYZE TABLE <Table_Name> LIST CHAINED ROWS;
It assumes that you already have table named CHAINED_ROWS
defined in your db( UTLCHAIN.SQL file is supposed to contain
these definitions ).

Anyway, run following statement :
SELECT NAME,VALUE FROM V$SYSSTAT WHERE NAME LIKE 'table%'
ORDER BY NAME;
Look for the VALUE for 'table fetch continued rows'.
If it's > 0 - you are actually accessing chained rows and
the performance suffers.

 Good luck. Michael.
In article <354F2F3A.87C00EF9@microware.demon.co.uk>#1/1,
  ij@microware.demon.co.uk wrote:
>
> Hi all,
>
> Nice easy one for a guru somewhere. According to the analysis software
> that I'm using I have a 'PCTFREE too low for a table' error reported
> against 'chained fetch ratio'. Ok, I understand the concept of chained
> rows, but how do I find out which table the error refers to. I've
> checked every table in the database that I can find with a column
> 'chain_cnt' and they all report zero. Don't know where else to look.
>
> Many thanks for any assistance.
>
> TIA
>
> --
> ************************************************************
> Ian Jennings
> Microware Data Services
>
> This post is made entirely from recycled ones and noughts
> ************************************************************
>
>


-----== Posted via Deja News, The Leader in Internet Discussion ==-----
http://www.dejanews.com/   Now offering spam-free web-based newsreading