Help please: Row chaining issues

Hi,

We have been told by Oracle that we are suffering in performance in our 7.3.4 databases because our ratio of table fetch by rowid to table fetch continued row is consistently below 1000. Does anyone know of any 'white papers' on row chaining? We have been doing export/imports of tables where there exist chained rows, however, we are finding that unless we reload every table with chained rows we still have fairly poor ratio numbers. Some of the tables affected are in sys so I guess we cannot attack those without doing a full database reload.

I suspect that 'chained' rows includes both rows that have been migrated and rows that are chained simply because some rows are too big to fit into our 4k database block.

Any advice on row chaining would be helpful.

Thanks,
Rob Ellis
rob.ellis_at_cognos.com Received on Thu May 06 1999 - 09:31:11 CDT