Does Gather_table_stats Detect Chained Rows (Doc ID 373091.1)

Last updated on MARCH 03, 2025

Applies to:

Goal

Q1: We previously used ANALYZE ... COMPUTE STATISTICS to gather our statistics. It
listed the number of chained rows in the CHAIN_CNT column of the DBA_TABLES
view when it was complete. We are now using the GATHER_STATS_JOB and
GATHER_TABLE_STATS procedures. They do not seem to populate the CHAIN_CNT
column in either DBA_TABLES or DBA_TAB_STATISTICS. Is this correct?




Q2: Is there any way to make these procedures populate the CHAIN_CNT column or do we have to
continue to use the ANALYZE ... LIST CHAINED ROWS command to detect chained
rows?





Q3: If we have to continue using ANALYZE ... LIST CHAINED ROWS, is that a
blocking process when the LIST CHAINED ROWS clause is used or can it be run
online without impacting users?

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.