Last updated on JULY 17, 2017
Applies to:Oracle Database - Enterprise Edition - Version 18.104.22.168 to 22.214.171.124 [Release 11.1]
Information in this document applies to any platform.
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:-
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms