1 Reply Latest reply on Jun 7, 2017 9:52 AM by mandevil

    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.



        • Re: re-enable query advisor

          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.

          1 of 1 people found this helpful