SQL Tuning Adviser run when analyzing a SQL Tuning Set (20 sql_id's) yields only ORA-600 [kestsaFina
edited Mar 15, 2019 8:57AM in Managing Databases using Enterprise Manager (MOSC) 2 commentsAnswered ✓
Hi MOSC,
We created a SQL Tuning Set of (20) sql_ids and scheduled a SQL Tuning Advisor to analyze and report findings.
However the post report yields no findings only "ORA-600 [kestsaFinalRound:1]" for each sql_id it analyzed.
We have a clinical data system and are currently locked into and engineered system; ODA X5-2, 11.2.0.2.4 release.
SQL Tuning Set is named: "SQL_Tuning_wun4" and contains (20) mview sql statements.
I found a possible connection to above's error code with "Doc ID 2407464.1" but it applies to 12.2 EE and the "arguments" section of
my ora-600 do not match up with the arguments sections of the Doc ID and subsequent bug (
Tagged:
0