This is from the database instance metrics, category is Throughput. Most
likely it’s enabled in a template, but it could be set on one particular
instance. I don’t believe this is tracked per SQL, but should be able to
find that detail in ADDM.
https://docs.oracle.com/en/enterprise-manager/cloud-control/enterprise-manager-cloud-control/13.4/emdbm/database-instance.html#GUID-4C51062A-4B01-411A-8C56-2D20ED9A8C27
User Action
View the latest Automatic Database Diagnostic Monitor (ADDM) report. For a more
detailed analysis, run ADDM from the Advisor Central link on the Database Home
page.
Courtney Llamas | Strategic Customer Program | +1.713.374.2102
Oracle Manageability <https://www.oracle.com/manageability/>
On Sep 28, 2020, at 8:37 AM, Reen, Elizabeth <dmarc-noreply@xxxxxxxxxxxxx>
wrote:
OEM is alerting on this metric. From what I understand we are
traversing the index in reverse order. OEM does not give any more information
than this. Where is the alert coming from? I can’t find any information on
it. I would like to find the indexes this is happening on and possibly the
sql id.
Thanks,
Liz