--统计信息
--收集schame的统计信息
begin
dbms_stats.gather_schema_stats(ownname => 'DATACHG',
estimate_percent => dbms_stats.auto_sample_size,
cascade => true,
method_opt => 'FOR ALL COLUMNS SIZE auto',
degree => 8);
end;
/
--收集表统计信息
begin
dbms_stats.gather_table_stats(ownname => 'LIS',
tabname => 'LACOMMISION',
estimate_percent => dbms_stats.auto_sample_size,
cascade => true,
method_opt => 'FOR ALL COLUMNS SIZE auto',
degr