Full Table Scans
- Organization of this page
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 Information |
Product |
RM Oracle(8.0) |
|
Alarm message |
Non-index lookups %CVS% |
|
|
Enable alarm |
Selected |
|
|
Alarm notification |
Notify when the state changed |
|
|
Notification target |
State changes for the alarm |
|
|
Evaluate all data |
Not selected |
|
|
Monitoring time range |
Always |
|
|
Report alarm when the following damping condition is reached |
Not selected |
|
|
occurrence(s) during |
-- |
|
|
interval(s) |
-- |
|
|
Alarm Conditions |
Record |
System Stat Summary Interval (PI) |
|
Field |
Non-Index Lookups % |
|
|
Abnormal condition |
Non-Index Lookups % > 10 |
|
|
Warning condition |
Non-Index Lookups % > 5 |
|
|
Actions |
|
-- |
|
Command |
-- |
|
|
SNMP |
Abnormal, Warning, Normal |
|
- Legend:
-
--: The setting is always invalid.
Related reports
Reports/RM Oracle/Troubleshooting/Recent Past/Full Table Scans