临时表处理办法

删除统计信息并锁定

exec dbms_stats.delete_table_stats(ownname => 'scott',tabname =>'a');

exec dbms_stats.lock_table_stats(ownname => 'scott',tabname =>'a');
exec dbms_stat.unlock_table_stats(ownname => 'scott',tabname =>'a');