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 size are returned every time this metric is collected.
Collection frequency - Every 60 minutes
Table 3-49 Top Ten Big 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. |
For Release 6 Number of Processes Currently Accessing the Object (per sec) For Release 7 Process Access Rate of the Object (per sec) |
For System Monitoring Plug-In for Sybase Adaptive Server Enterprise (ASE) Release 6 (1.0.1.0.0) Number of processes currently accessing the object. For System Monitoring Plug-In for Sybase Adaptive Server Enterprise (ASE) Release 7 (1.1.1.0.0) 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. |
DBID |
Database identifier. |
Index ID |
Index identifier. |
Object ID |
Object identifier. |
Owner UID |
Owner user ID. |