Hitachi

JP1 Version 12 JP1/Performance Management - Remote Monitor for Oracle Description, User's Guide and Reference


Full Table Scans

Organization of this page

Overview

The Full Table Scans report displays the percentage of table lookups using no index per minute over the past hour.

Storage location

Reports/RM Oracle/Troubleshooting/Recent Past/

Record

System Stat Summary Interval (PI)

Fields

Field name

Description

Non-Index Lookups %

Percentage ratio of full table scans that do not involve caching

Drilldown reports (field level)

Report name

Description

Cache Usage

Displays the buffer cache usage ratio. To display this report, choose the Non Index Lookups % field.