Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

getting chained rows

582889Jul 19 2009 — edited Jul 21 2009
Hello

Is there a diffrence between, getting the chanined tables from the below two queries




1-) analyze all tables and then
select table_name,chain_cnt from dba_tables

2-) analyze table LIST CHAINED ROWS;
select * from chained_rows;
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 18 2009
Added on Jul 19 2009
17 comments
2,125 views