2.9.2 Notes on monitoring Oracle Database 12c Release 2 or later
- Organization of this subsection
(1) Notes on monitoring all version of Oracle Database 12c Release 2 or later
-
PFM - RM for Oracle collects performance data of the record field size from Oracle. Therefore, if Oracle contains data that exceeds the field size, the last character of the performance data might be unreadable. The following table lists the applicable fields:
Record name
Field name
Lock Waiters (PD_PDLW)
Holding User
Waiting User
Open Cursor (PD_PDOC)
User
Session Detail (PD_PDS)
Module
OS User
Schema Name
User
Session I/O Interval (PI_PIIO)
User
Session Statistics Summary (PD_PDS2)
User
Transaction (PD_PDTR)
User
Transaction Lock (PD_PDTL)
Object Name
Owner
User
-
If you set the INSTANCE_MODE Oracle Database initialization parameter to READ-MOSTLY or READ-ONLY, PFM - RM for Oracle cannot collect the performance information.
-
To use Oracle Client 12c or later (about Oracle Client 18c) to monitor an Oracle Database, set to oracle_version instance information is 12. If set a value invalid, the following message appears:
KAVE05924-W An invalid character string was entered.
(2) Notes on monitoring verison of Oracle Database 18c or later
When set the OPTIMIZER_IGNORE_HINTS initialization parameter in enable, it may take an amount of time to perform record collection. In this case, consider that disable the initialization parameter.