List of alarms
An alarm table named PFM Oracle Template Alarms 12.10 contains the alarms that are defined in the monitoring template for PFM - Agent for Oracle (12.10 indicates the version of the alarm table). This alarm table is stored in the Oracle folder that is displayed on the Alarms window of PFM - Web Console. The following table lists the alarms defined in the monitoring template.
Note that if the monitoring target is Oracle Database 12c Release 2 or later in a CDB configuration, some records or fields collect the following performance data:
-
Performance data for the PDBs and root container (CDB$ROOT) that are being monitored
-
Performance data for all PDBs and common performance data for database instances
For details, see 6. List of records for PFM - Agent for Oracle.
Alarm name |
What is monitored |
---|---|
Buffer cache usage ratio |
|
Contention for data in the database and rollback blocks |
|
Shared pool |
|
Percentage of all sort operations executed on disk using memory and disk I/O operations |
|
Contention on free lists |
|
Percentage of full table scans |
|
Library cache |
|
Occurrence frequency of wait events |
|
Availability of an Oracle instance. |
|
Available tablespace |
- Notes:
-
-
Due to the sort performed by PFM - Agent for Oracle, if you use the alarm table PFM Oracle Template Alarms MM.NN# provided by the monitoring template to perform monitoring, a Disk Sorts alarm may occur. If the error occurs, increase the value of the initial parameters SORT AREA SIZE and SORT AREA RETAINED SIZE of Oracle appropriately. When you set the new values, restart Oracle to enable the settings.
-
Due to the table scan performed by PFM - Agent for Oracle, if you use the alarm table PFM Oracle Template Alarms MM.NN# provided by the monitoring template to perform monitoring while only PFM - Agent for Oracle is manipulating the database, a Full Table Scans alarm may occur.
-
When PFM - Agent for Oracle does not connect to the monitoring target Oracle, PFM - Agent for Oracle does not detect any alarms except Server Status.
- #
-
MM.NN is version of the data model of the alarm table.
-