Just analyze table xxx list chained rows and use the procedure titled "Reducing Migrated and Chained Rows" in the "Designing and Tuning for Performance" guide, chapter 20. I've used this on large tables and it works quite well.
Steve Orr, Bozeman, Montana -----Original Message----- Sent: Tuesday, January 08, 2002 8:46 AM To: Multiple recipients of list ORACLE-L It depends on the number. If it's a real high number on the tables that are actively involved in OLTP (or just queried a lot, for that matter), chained (or migrated) rows will definitely slow down the processing. In this case you can either use EXP/IMP on the tables or create a copy of the table (CTAS), truncate the table and INSERT INTO ...(...) SELECT (*)...; Regards, Sergey Babich, Oracle DBA -----Original Message----- Sent: Tuesday, January 08, 2002 8:36 AM To: Multiple recipients of list ORACLE-L I have seen that There are some number of chained rows in several tables of a schema in my database. What is it done in such a situation ? Thank you Bunyamin -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).