Query:
SELECT owner, table_name, chain_cnt FROM dba_tables WHERE chain_cnt > 0;
SELECT owner_name,table_name,count(head_rowid) row_countFROM chained_rows
GROUP BY owner_name,table_name
Recent Posts
Query:
SELECT owner, table_name, chain_cnt FROM dba_tables WHERE chain_cnt > 0;
SELECT owner_name,table_name,count(head_rowid) row_countFROM chained_rows
GROUP BY owner_name,table_name