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