{統計}列グループの統計を取得

 

https://docs.oracle.com/cd/F19136_01/tgsql/managing-extended-statistics.html#GUID-CE34B506-94B6-4346-8AB6-6B17BC52B782

begin
dbms_stats.gather_table_stats(
'sh',
'tokei',
method_opt =>'for columns(col2,col3) size 254'
);
end;
/
 
select * from dba_tab_col_statistics where table_name ='TOKEI';

SELECT *
FROM   DBA_STAT_EXTENSIONS 
WHERE  TABLE_NAME='TOKEI';