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
SQL> show parameter cursor_sharing
NAME TYPE VALUE
------------------------------------------------------ ------------------------------
cursor_sharing string SIMILAR
2 清空一下共享池
SQL> alter system flush shared_pool;
System altered.
3.分析方案对象
execute dbms_utility.analyze_schema('INSUR_CHANGDE','compute');