I have recently been reviewing the Sql Monitor Tool through OEM. Yes, we have license.
My question is the only statements that show up in SQL Monitor are Sys statements. The user statements are not showing up. I suspect we are not collecting some stats or something to enable all statements to show.
Any assistance is greatly appreciated.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.