Does Gather_table_stats Detect Chained Rows (Doc ID 373091.1)

Last updated on DECEMBER 15, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.2 and later
Information in this document applies to any platform.
Information in this document applies to any platform.
***Checked for relevance on 15-Dec-2016***

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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms