Even After Applying Bug 26764561 Error 'ORA-00933 IN SYS.WRI$_ADV_SQLTUNE.SUB_DELETE_EXECUTION' (Doc ID 2467646.1)

Last updated on APRIL 17, 2023

Applies to:

Oracle Database - Enterprise Edition - Version 12.2.0.1 and later
Information in this document applies to any platform.

Applied 12.2.0.1.180831 (Aug 2018) Bundle Patch for Windows Platforms to fix bug 26764561 - SQL TUNING Tasks may Fail With: ORA-00933: SQL command not properly ended
But Error still persists:
WARNING: too many parse errors, count=2449 SQL hash=0x750004bb
PARSE ERROR: ospid=36100, error=933 for statement:
2018-10-23T00:18:47.682457-04:00
DELETE FROM wri$_adv_sqlt_rtn_planWHERE task_id = :tid AND exec_name = :execution_name
Additional information: hd=00007FFDBCE0B538 phd=00007FFDBCE0BC90 flg=0x28 cisid=0 sid=0 ciuid=0 uid=0
2018-10-23T00:18:47.698095-04:00
----- PL/SQL Call Stack -----
object line object
handle number name
00007FFDBE7672D8 259 type body SYS.WRI$_ADV_SQLTUNE.SUB_DELETE_EXECUTION
00007FFDBE49C600 2134 package body SYS.PRVT_ADVISOR.COMMON_DELETE_TASK
00007FFDBE49C600 7342 package body SYS.PRVT_ADVISOR.DELETE_EXPIRED_TASKS
00007FFDBE6F13B8 1 anonymous block
WARNING: too many parse errors, count=2549 SQL hash=0x750004bb
PARSE ERROR: ospid=36100, error=933 for statement:

	To view full details, sign in with your My Oracle Support account.
	Don't have a My Oracle Support account? Click to get started!

In this Document

Symptoms

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.