{統計}式の統計を取得

 

https://docs.oracle.com/cd/F19136_01/tgsql/managing-extended-statistics.html#GUID-FC50E35E-AF6A-4ECD-919D-8E020011DAB6

begin
dbms_stats.gather_table_stats(
'sh',
'tokei',
method_opt =>'for columns(col1+col4) size 254'
);
end;
/

select * from dba_tab_col_statistics where table_name ='TOKEI';

SELECT *
FROM   DBA_STAT_EXTENSIONS 
WHERE  TABLE_NAME='TOKEI';