ORA-13605: THE SPECIFIED TASK OR OBJECT DOES NOT EXIST FOR THE CURRENT USER (Doc ID 822076.1)

Last updated on JULY 17, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 11.1.0.6 to 11.1.0.7 [Release 11.1]
Information in this document applies to any platform.

Symptoms

Generally SQL Performance Analyzer (SPA) is used to test the post upgrade performance alongside Oracle Real Application Testing.

While using EM dbconsole to check on regressed SQL statements found by SPA, the following error appears:-



Step-by-Step Instructions

login to em dbconsole:
as sys sysdba

Database instance -> Advisor Central -> SQL Performance Analyzer
-> SQL Performance Analyzer Task Result: SYS."stit_task" -> Comparison Report
-> Regressed SQL Statements
-> select sql id that regressed 1% : 6rhsvq2pabpwu (SQL ID)
 
Then the error occurs. The details for the selected SQLID do not appear.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms