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');