Full Table Scans

Overview

The Full Table Scans alarm monitors the percentage of full table scans.

Main settings

Alarm properties in PFM - Web ConsoleSetting
ItemDetailed item
MainProductRM Oracle
Message textNon-index lookups %CVS%
Enable alarmSelected
Evaluate all dataNot selected
Monitoring time rangeAlways
Alarm when damping conditions are satisfiedNot selected
Interval--
Maximum occurrences--
ActionsE-mail--
Command--
SNMPAbnormal, Warning, Normal
Conditional ExpressionsRecordSystem Stat Summary Interval (PI)
FieldNon-Index Lookups %
Abnormal conditionNon-Index Lookups % > 10
Warning conditionNon-Index Lookups % > 5
Legend:
--: The setting is always invalid.

Related reports

Reports/RM Oracle/Troubleshooting/Recent Past/Full Table Scans