Re: Chained fetch ratio

Ian Jennings <ij_at_microware.demon.co.uk> wrote in article <354F2F3A.87C00EF9_at_microware.demon.co.uk>...
> 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
> ************************************************************
>
>
>

I think I've understand your problem. On ORACLE_HOME/rdbms/admin directory you can find utlchain.sql script. Run it connecting with your schema userid. And then, for every table of your schema, issue the following command:

ANALYZE TABLE table_name LIST CHAINED ROWS INTO CHAINED_ROWS;

After this operation run this select:

SELECT TABLE_NAME
             ,COUNT(*)
FROM CHAINED_ROWS
GROUP BY TABLE_NAME; You will have the list of the tables (table_name) which have at least one chained row, with the number of chained rows (count).

Bye. Received on Wed May 06 1998 - 08:19:11 CDT