Re: Metrics Full Index Scans Per Sec is at 2,551.756

 The metric name is a bit misleading but the description is correct. It counts 'INDEX FAST FULL SCAN' rather than 'INDEX FULL SCAN' operations as I thought initially judging by its name.

It should be coming from V$SYSMETRIC-family views:

select begin_time, end_time, value from v$sysmetric where metric_name='Full Index Scans Per Sec';

You can take a look at the 'Segment Statistics/Segments by Table Scans' section of your AWR report, or query
v$segment_statistics/dba_hist_segstat_obj to find out indexes with the highest number of the 'segment scans' statistic.

Best regards,
Mikhail Velikikh

On Mon, 28 Sep 2020 at 15:03, Courtney Llamas <COURTNEY.LLAMAS_at_oracle.com> wrote:

> 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_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