This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.
You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

re-enable query advisor

I disabled a query for analysis advisor for it is a batch job.

But I wonder if there is a way to re-enable it.

Thanks

  • select name, id from cond;  -- this will give the id for the db you are tracking down the disabled query analysis for

    select * from con_problem_silence_<Id from above>

    this will show if there are any sql ids that are silenced and the date of the silencing

    You can delete the row from con_problem_silence_<id> to get the analysis to start again on that statement.