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 |
Oracle(9.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/Oracle/Troubleshooting/Recent Past/Full Table Scans (8.0)