The metrics in this category provide statistics for all objects and indexes with pages currently in a data cache.
Only top 10 rows sorted on the frequency of access are returned every time this metric is collected.
Collection frequency - Every 60 minutes
Table 3-50 Top Ten Frequently Accessed Cached Objects Metrics
Metric | Description |
---|---|
Cached Object Size |
Number of kilobytes of the cache the object is occupying. |
Cache Name |
Name of the cache. |
DB Name |
Name of the database. |
Object Name |
Name of the object. |
Object Type |
Type of object. |
Owner Name |
Name of the object owner. |
Process Access Rate of the Object (per sec) |
Rate at which the processes are currently accessing the object, that is, the number of processes that have started accessing the object since last collection divided by the elapsed time between two collections. |
Cache ID |
Cache identifier. |
Cache Name |
Name of the cache. |
Cached Object Size (KB) |
Number of kilobytes of the cache the object is occupying. |
DB Name |
Name of the database. |
DBID |
Database identifier. |
Index ID |
Index identifier. |
Object Name |
The name of the object. |
Object ID |
Object identifier. |
Owner UID |
Owner user ID. |