how to determine number of chained rows
From: Jeffrey Beckstrom <JBECKSTROM_at_gcrta.org>
Date: Mon, 15 Apr 2013 10:57:53 -0400
Message-Id: <516BDD310200000B00500ED6_at_groupwise.gcrta.org>
DBMS_STATS does not compute number of chained rows. analyze table x list chained rows - this does but if the table is large and has lots of chained rows, then need a lot of rollback space for rows inserted into the chained_rows table.
Date: Mon, 15 Apr 2013 10:57:53 -0400
Message-Id: <516BDD310200000B00500ED6_at_groupwise.gcrta.org>
DBMS_STATS does not compute number of chained rows. analyze table x list chained rows - this does but if the table is large and has lots of chained rows, then need a lot of rollback space for rows inserted into the chained_rows table.
Is there another way to just get a count of chained rows?
Jeffrey Beckstrom
Database Administrator
Greater Cleveland Regional Transit Authority
Information Systems
1240 W. 6th Street
Cleveland, Ohio 44113
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Apr 15 2013 - 16:57:53 CEST