Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Chained fetch ratio
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 --
This post is made entirely from recycled ones and noughts