My Oracle Support Banner

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

Last updated on SEPTEMBER 13, 2023

Applies to:

Oracle Database - Enterprise Edition - Version 11.1.0.6 to 11.1.0.7 [Release 11.1]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
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

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


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