select count(*)
FROM   dba_tab_col_statistics
WHERE  owner='&owner'
and histogram <> 'NONE'
;
SELECT column_name, num_distinct, histogram
FROM   dba_tab_col_statistics
WHERE  owner='&owner'
-- and table_name in ('xxx')
and histogram <> 'NONE'
/