Oracle 12.2出现SYS.WRI$

Oracle 12.2出现SYS.WRI$"/>

Oracle 12.2出现SYS.WRI$

数据库版本：

SQL> col banner for a100;
SQL> set linesize 1000;
SQL> select * from v$version;BANNER                                                                                                   CON_ID
---------------------------------------------------------------------------------------------------- ----------
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production                                  0
PL/SQL Release 12.2.0.1.0 - Production                                                                        0
CORE    12.2.0.1.0      Production                                                                                    0
TNS for Linux: Version 12.2.0.1.0 - Production                                                                0
NLSRTL Version 12.2.0.1.0 - Production                                                                        0

alert日志告警内容：

2021-04-11T08:16:20.785935+08:00
WARNING: too many parse errors, count=100 SQL hash=0x750004bb
PARSE ERROR: ospid=47696, error=933 for statement: 
2021-04-11T08:16:20.786062+08:00
DELETE FROM wri$_adv_sqlt_rtn_planWHERE task_id = :tid AND exec_name = :execution_name
Additional information: hd=0x2fe29a4e0 phd=0x2adf94540 flg=0x28 cisid=0 sid=0 ciuid=0 uid=0 

参照MOS文档：

Bug 26764561 - SQL TUNING Tasks may Fail with: ORA-00933: SQL command not properly ended (SYS.WRI$_ADV_SQLTUNE.SUB_DELETE_EXECUTION) (Doc ID 26764561.8)

解决方法：
打补丁：Patch 26764561: ORA-00933 IN SYS.WRI$_ADV_SQLTUNE.SUB_DELETE_EXECUTION

打完补丁后，若仍出现933报错，参照MOS文档：
Even After Applying Bug 26764561 Error ‘ORA-00933 IN SYS.WRI$_ADV_SQLTUNE.SUB_DELETE_EXECUTION’ (Doc ID 2467646.1)
在数据库中执行@?/rdbms/admin/prvtsqli.plb

SQL> @?/rdbms/admin/prvtsqli.plbSession altered.Type body created.No errors.Package body created.No errors.Type body created.No errors.Type body created.No errors.Grant succeeded.Session altered.