1 修改參數
sql> show parameter cursor_sharing
name type value
------------------------------------ -------------------------------- ------------------------------
cursor_sharing string force
如果cursor_sharing=force,那麼就修改成為similar;
[kkslgbv0]與cursor_sharing相關,最好用其預設值"exact ".
sql> alter system set cursor_sharing=similar;
system altered.
elapsed: 00:00:00.00
------------------------------------------------------ ------------------------------
cursor_sharing string similar
2 清空一下共享池
sql> alter system flush shared_pool;
3.分析方案對象
execute dbms_utility.analyze_schema('insur_changde','compute');