RE: CHAINED ROWS

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: sorr_at_rightnow.com

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: ListGuru_at_fatcity.com (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).