6.3.6.1 Monitoring PMEM Log Using Database Statistics and Wait Events
The following table describes database statistics that are useful for
monitoring PMEM Log performance. The statistics are available in various dynamic
performance views, including V$SYSSTAT
, and may be displayed in the
Global Activity Statistics or Instance Activity Statistics section of an AWR report.
Statistic | Description |
---|---|
|
The number of redo log write requests that used PMEM log The statistic is named |
The following table describes database wait events that are useful for
monitoring PMEM Log performance. The wait events are visible in various dynamic
performance views, including V$SESSION
, V$SYSTEM_EVENT
and V$SESSION_EVENT
, and may be displayed in the Wait Event sections of
the AWR report.
Wait Event | Description |
---|---|
log file parallel write |
The Oracle Database log writer (LGWR) process waits on this event when it is waiting for the completion of writes to the redo log file. Efficient use of PMEM Log is indicated by comparatively lower time waiting on this event. |
The availability of a specific statistic or wait event is subject to the version of Oracle Database being used.
Parent topic: Monitoring PMEM Log