2.7.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 - Agent 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
Circuit (PD_PDCI)
User
Database Object Cache (PD_PDDO)
Owner
Latch (PD_PDLA)
OS User
User
Latch Interval (PI_PILA)
OS User
User
Lock (PD_PDLO)
User
Lock Interval (PI_PILO)
User
Lock Waiters (PD_PDLW)
Holding User
Waiting User
Open Cursor (PD_PDOC)
User
Resource Limit (PD_PDRL)
Resource Name
Segment Detail (PD_PDSM)
Owner
Segment Name
Session Detail (PD_PDS)
Module
OS User
Schema Name
User
Session Event (PD_PDEV)
User
Session Event Interval (PI_PIEV)
User
Session I/O Interval (PI_PIIO)
User
Session Stat Summary Interval (PI_PIS2)
User
Session Statistics (PD_PDSS)
User
Session Statistics Summary (PD_PDS2)
User
Session Wait (PD_PDWA)
User
SQL Text - Performance Based (PD_PDES)
Parsing User
Table Access (PD_PDTA)
Owner
User
Transaction (PD_PDTR)
User
Transaction Interval (PI_PITR)
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 - Agent for Oracle cannot collect the performance information.
-
When monitoring target is Oracle Database 12c or later (about Oracle Database 18c), and 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.