My Oracle Support Banner

ORA-00933 IN SYS.WRI$_ADV_SQLTUNE.SUB_DELETE_EXECUTION (Doc ID 2691874.1)

Last updated on SEPTEMBER 11, 2020

Applies to:

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

Symptoms

2020-06-30T20:34:57.665761+05:30

WARNING: too many parse errors, count=100 SQL hash=0x750004bb​

PARSE ERROR: ospid=41025926, error=933 for statement:​

2020-06-30T20:34:57.668495+05:30​

DELETE FROM wri$_adv_sqlt_rtn_planWHERE task_id = :tid AND exec_name = :execution_name​

Additional information: hd=70001009eaa3c28 phd=700010141bbfdf0 flg=0x28 cisid=0 sid=0 ciuid=0 uid=0​

2020-06-30T20:34:57.671618+05:30​

----- PL/SQL Call Stack -----​

  object line object​

  handle number name​

70001013f6a74d0 259 type body SYS.WRI$_ADV_SQLTUNE.SUB_DELETE_EXECUTION​

700010014374b68 2134 package body SYS.PRVT_ADVISOR.COMMON_DELETE_TASK​

700010014374b68 7342 package body SYS.PRVT_ADVISOR.DELETE_EXPIRED_TASKS​

70001001635fd48 1 anonymous block​

WARNING: too many parse errors, count=200 SQL hash=0x750004bb​

PARSE ERROR: ospid=41025926, error=933 for statement:​

2020-06-30T20:34:57.886245+05:30​

Changes

 The problem can persist if we disable SQL tuning advisor also

Cause

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
Changes
Cause
Solution


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