Verificando histogramas

Query para verificar informações sobre os histogramas gerados pelas estatísticas:

SELECT rownum num,column_name,type,len,precision,scale,histogram,buckets, nullok

         FROM (

               SELECT c.column_name,

                      c.data_type as type,

                      c.data_length as len,

                      c.data_precision as precision,

                      c.data_scale as scale,

                      c.histogram,

                      h.buckets,

                      c.nullable as nullok

               FROM dba_tab_columns c,

                    (SELECT owner,table_name,column_name,count(*) as buckets

                     FROM dba_histograms

                     WHERE owner=&&OWN and

                           table_name=&&TAB

                     GROUP BY owner,table_name,column_name ) h

               WHERE c.owner=&&OWN and

                     c.table_name=&&TAB and

                     c.table_name = h.table_name(+) and

                     c.column_name = h.column_name(+) and

                     c.owner = h.owner(+)

               ORDER BY c.column_id);

 

 

Fonte: http://www.dba-oracle.com/t_gather_stats_job.htm