-- -----------------------------------------------------------------------------------
-- File Name    : extended_stats.sql
-- Author       : DBA Learning Hub
-- Description  : Provides information about extended statistics.
-- Requirements : Access to the DBA views.
-- Call Syntax  : @extended_stats
-- Last Modified: 15/07/2025
-- -----------------------------------------------------------------------------------
SET LINESIZE 200
COLUMN owner FORMAT A20
COLUMN extension_name FORMAT A15
COLUMN extension FORMAT A50

SELECT owner, table_name, extension_name, extension
FROM   dba_stat_extensions
ORDER by owner, table_name;