I got task - "send me the query used in this metric?"

It is related to Job with status "FAILED".

I find this failed Job but can't find with which query this metric detect this error.

  • Not sure if this helps
    – user153556
    Commented Jun 23, 2020 at 20:49
  • Yes, I already find something in documentation. "mgmt$annotations" view could help to identify. But it is not clearly how to check via OEM console for queries which use in metrics.
    – Smenov
    Commented Jun 25, 2020 at 9:37

1 Answer 1


After 2 months of SR to Oracle started we finally get one-off patch for this issue. Oracle recognized it as official bug. Patch number is 33074193: Jobs stuck in scheduled status after RU9 applied on OMS

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.