how to determine number of chained rows
- From: "Jeffrey Beckstrom" <JBECKSTROM@xxxxxxxxx>
- To: "oracle-l-freelists" <oracle-l@xxxxxxxxxxxxx>, "oracle-db-l" <oracle-db-l@xxxxxxxxxxxxxxxxxxxx>
- Date: Mon, 15 Apr 2013 10:57:53 -0400
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
