The capability of PFM - RM for Oracle to monitor operating status can be enhanced through linkage with JP1/ITSLM.
PFM - RM for Oracle provides default monitoring items specific to JP1/ITSLM for PFM - Manager to enable monitoring on JP1/ITSLM.
The default monitoring items provided by PFM - RM for Oracle for PFM - Manager are described in the following table.
In addition, PFM - RM for Oracle collects records corresponding to the value specified as the key for multi-instance records. For the corresponding collection key, see the collection result for each record.
Table L-1 Default monitoring items provided by PFM - RM for Oracle for PFM - Manager
Display name in JP1/ITSLM | Description | Record (Record ID) | Key (PFM-Manager name) | Field name |
---|---|---|---|---|
Cache miss rate | Monitors the percentage of data requests issued due to cache misses. | System Stat Summary Interval (PI) | -- | DICTIONARY_CACHE_GET_MISSES_PERCENTAGE |
Disk sorts execution rate | Monitors the percentage of all sorts executed on the disk when memory or disk I/O is used. | System Stat Summary Interval (PI) | -- | SORT_OVERFLOW_PERCENTAGE |
Buffer cache usage rate | Monitors buffer and cache usage. | System Stat Summary Interval (PI) | -- | CACHE_HIT_PERCENTAGE |
Buffer busy rate | Monitors the percentage of rollback or data conflicts in a database. | System Stat Summary Interval (PI) | -- | BUFFER_BUSY_WAIT_PERCENTAGE |
Library cache miss rate | Monitors the percentage of the objects in the library cache that are reloaded. | System Stat Summary Interval (PI) | -- | LIBRARY_CACHE_MISS_PERCENTAGE |
To provide the default monitoring items for PFM - Manager, you need to copy the setup file and execute the setup command. For details, see 2.1.4(1) Register PFM - RM for Oracle (Windows) or 2.2.4(2) Register PFM - RM for Oracle (UNIX).