Xref: alice comp.databases.oracle.server:20279 Path: alice!news-feed.fnsi.net!newsfeed.direct.ca!btnet-peer!btnet!dispose.news.demon.net!demon!news.demon.co.uk!demon!microware.demon.co.uk!not-for-mail From: Ian Jennings Newsgroups: comp.databases.oracle.server Subject: Chained fetch ratio Date: Tue, 05 May 1998 16:24:43 +0100 Organization: Microware Data Services Message-ID: <354F2F3A.87C00EF9@microware.demon.co.uk> Reply-To: ij@microware.demon.co.uk X-Trace: news.demon.co.uk 894381777 nnrp-11:23839 NO-IDENT microware.demon.co.uk:194.222.151.59 X-Complaints-To: abuse@demon.net X-Mailer: Mozilla 4.05 [en] (Win95; I) MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Lines: 22 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 ************************************************************