L. Linking with JP1/SLM
The capability of PFM - Agent for Oracle to monitor operating status can be enhanced through linkage with JP1/SLM.
PFM - Agent for Oracle provides default monitoring items specific to JP1/SLM for PFM - Manager to enable monitoring on JP1/SLM.
The default monitoring items provided by PFM - Agent for Oracle for PFM - Manager are described in the following table.
In addition, PFM - Agent 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.
Display name in JP1/SLM |
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(2) Register PFM - Agent for Oracle (for Windows) or 3.1.4(2) Register PFM - Agent for Oracle (for UNIX).