📋Steps in this guide1/1

Find chained rows in table

-- First, analyze the table as below:

oracle configurationintermediate

by OracleDba

16 views

Find chained rows in table

-- First, analyze the table as below: -- Then check the row_count in chained_row table

Code/Command (click line numbers to comment):

1
2
3

ANALYZE TABLE SCOTT.EMPTABLE LIST CHAINED ROWS;
select count(*) from chained_rows where table_name='EMPTABLE';
The output of this query returns the number of chained rows in that table.

Comments (0)

Please to add comments

No comments yet. Be the first to comment!