Mysterious missing sql_id
Hi,
Trying to run sql advisor for a sql statement, got the job ran several times recently including one run today in the morning, can find stats for the sql, but got "SQL statement does not exist" error when trying to run sqltune, anyone ran into this wired situation before? Idea to clear the error?
-- Can find this sql_id in history (don't know why got this table format when paste from text output):
SQL_ID | PLAN_HASH_VALUE | minutes | SNAP_ID BeginTime |
------------- --------------- ---------- ---------- -----------------
bakdnvajk95c3 | 1814474568 | 12.4 | 983 03-20-20 10:00:03 |
bakdnvajk95c3 | 816061781 | 6.6 | 958 03-19-20 09:00:40 |
bakdnvajk95c3 | 1814474568 | 17.9 | 966 03-19-20 17:00:06 |