analyze table db_name.table_name compute statistics for columns;
select * from TAB_COL_STATS@system_dblink where db_name = 'db_name' and table_name = 'table_name';
例如:
analyze table ADS.USR_CRMFUTURES_DF compute statistics for columns;
select column_name,max_col_len from TAB_COL_STATS@system_dblink where db_name = 'ADS' and table_name = 'USR_CRMFUTURES_DF';