re-enable query advisor

Question

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

mandevil · Accepted Answer

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_ 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_ to get the analysis to start again on that statement.