Re: Metrics Full Index Scans Per Sec is at 2,551.756
Date: Mon, 28 Sep 2020 08:59:47 -0500
Message-Id: <6CD0376B-11B2-4512-8DC0-29A4AB9D6714_at_ORACLE.COM>
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.
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_at_freelists.org> 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
--
http://www.freelists.org/webpage/oracle-l
Received on Mon Sep 28 2020 - 15:59:47 CEST