Full Table Scans
Overview
The Full Table Scans alarm monitors the percentage of full table scans.
Main settings
Alarm properties in PFM - Web Console | Setting | |
---|---|---|
Item | Detailed item | |
Main | Product | RM Oracle |
Message text | Non-index lookups %CVS% | |
Enable alarm | Selected | |
Evaluate all data | Not selected | |
Monitoring time range | Always | |
Alarm when damping conditions are satisfied | Not selected | |
Interval | -- | |
Maximum occurrences | -- | |
Actions | -- | |
Command | -- | |
SNMP | Abnormal, Warning, Normal | |
Conditional Expressions | Record | System Stat Summary Interval (PI) |
Field | Non-Index Lookups % | |
Abnormal condition | Non-Index Lookups % > 10 | |
Warning condition | Non-Index Lookups % > 5 |
Related reports
Reports/RM Oracle/Troubleshooting/Recent Past/Full Table Scans