ORA-00600: internal error code, arguments: [kkslgbv0], [], [], [], [], [], [], [ ]

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

发表评论

电子邮件地址不会被公开。