Find chained rows in table - oracle database script

-- First, analyze the table as below:  ANALYZE TABLE SCOTT.EMPTABLE LIST CHAINED ROWS;  -- Then check the row_count in chained_row table  select count(*) from chained_rows where table_name='EMPTABLE';  The output of this query returns the number of chained rows in that table.