Appendix L. Linking with JP1/ITSLM

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/ITSLMDescriptionRecord
(Record ID)
Key
(PFM-Manager name)
Field name
Cache miss rateMonitors the percentage of data requests issued due to cache misses.System Stat Summary Interval
(PI)
--DICTIONARY_CACHE_GET_MISSES_PERCENTAGE
Disk sorts execution rateMonitors 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 rateMonitors buffer and cache usage.System Stat Summary Interval
(PI)
--CACHE_HIT_PERCENTAGE
Buffer busy rateMonitors the percentage of rollback or data conflicts in a database.System Stat Summary Interval
(PI)
--BUFFER_BUSY_WAIT_PERCENTAGE
Library cache miss rateMonitors 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).