搜集直方图repeat和skewonly

SQL> set linesize 200
SQL>   select a.column_name,
                   b.num_rows,
                  a.num_distinct Cardinality,
                    round(a.num_distinct / b.num_rows * 100, 2) selectivity,
                   a.histogram,
                  a.num_buckets
              from dba_tab_col_statistics a, dba_tables b
             where a.owner = b.owner
              and a.table_name = b.table_name
            and a.owner = 'MBFE'
         and a.table_name = upper('messagein');  2    3    4    5    6    7    8    9   10   11  

COLUMN_NAME			 NUM_ROWS CARDINALITY SELECTIVITY HISTOGRAM	  NUM_BUCKETS
------------------------------ ---------- ----------- ----------- --------------- -----------
ID				   978619      978619	      100 NONE			    1
MSGID				   978619      978619	      100 FREQUENCY		    2
STATUS				   978619	    1		0 NONE			    1
PROCCNT 			   978619	    2		0 NONE			    1
ACCEPTTIME			   978619