-- Oracle 12c: Analysis of database objects (table, index,..)

ANALYZE TABLE table_name delete statistics
;

ANALYZE TABLE table_name estimate statistics sample 10 percent 
for table_name for all indexes for all indexed columns 
;

ANALYZE TABLE table_name VALIDATE STRUCTURE
;

-- Analyze table and all indexes

ANALYZE TABLE table_name VALIDATE STRUCTURE CASCADE 
;

-- Analyze table and check ROWID 

ANALYZE TABLE table_name VALIDATE REF UPDATE
;

-- Analyze table in live mode (during DML activities) 

ANALYZE TABLE table_name VALIDATE STRUCTURE ONLINE
;

-- The chained_rows table has to be created first
-- For Non-Index Organized Tables tables
--  UTLCHAIN.SQL

-- For Index Organized Tables (IOT) and conventional tables
--  UTLCHN1.SQL

ANALYZE TABLE table_name LIST CHAINED ROWS INTO chained_rows
;

SELECT * FROM chained_rows
;

ANALYZE CLUSTER cluster_name VALIDATE STRUCTURE CASCADE
;