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

    re-enable query advisor

    anncao

      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

        • Re: re-enable query advisor
          mandevil

          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