Last updated on JUNE 29, 2017

Applies to:

Symptoms

Enterprise Manger (EM) 12c Cloud Control sends alerts for Server Generated alerts as part of its monitoring function.
However, after disabling a metric group or individual metric, EM 12c continues to send alerts for server generated alerts for the disabled metric.

For example:

If the Throughput metric group has been disabled with some previously set values for the metric, EM 12c will still send emails with this type of content:


Target type=Database Instance
Target name=orcl
Categories=Load
Message=Metrics "Redo Generated Per Sec" is at 286.371
Severity=Warning
Event reported time=Jun 5, 2013 12:47:49 PM MDT
Operating System=Linux
Platform=x86_64
Associated Incident Id=13289
Associated Incident Status=New
Associated Incident Owner=
Associated Incident Acknowledged By Owner=No
Associated Incident Priority=Very High
Associated Incident Escalation Level=0
Event Type=Metric Alert
Event name=instance_throughput:redosize_ps
Metric Group=Throughput
Metric=Redo Generated (per second)
Metric value=286.370826742153
Key Value=SYSTEM
Rule Name=Test_Rule
Rule Owner=SYSMAN
Update Details:
Metrics "Redo Generated Per Sec" is at 286.371


Target type=Database Instance
Target name=orcl
Categories=Load
Message=Metrics "Logons Per Sec" is at 0.258
Severity=Critical
Event reported time=Jun 5, 2013 12:56:49 PM MDT
Operating System=Linux
Platform=x86_64
Associated Incident Id=13290
Associated Incident Status=New
Associated Incident Owner=
Associated Incident Acknowledged By Owner=No
Associated Incident Priority=Very High
Associated Incident Escalation Level=0
Event Type=Metric Alert
Event name=instance_throughput:logons_ps
Metric Group=Throughput
Metric=Cumulative Logons (per second)
Metric value=0.258053775077
Key Value=SYSTEM
Rule Name=Test_RULE
Rule Owner=SYSMAN

Some of the Server Generated Metrics:

=====================

Throughput Metrics

All Sessions
Average Active Sessions
Average Synchronous Single-Block Read Latency (ms)
BG Checkpoints (per second)
Branch Node Splits (per second)
Branch Node Splits (per transaction)
Consistent Read Blocks Created (per second)
Consistent Read Blocks Created (per transaction)
Consistent Read Changes (per second)
Consistent Read Changes (per transaction)
Consistent Read Gets (per second)
Consistent Read Gets (per transaction)
Consistent Read Undo Records Applied (per second)
Consistent Read Undo Records Applied (per transaction)
Cumulative Logons (per second)
Cumulative Logons (per transaction)
Database Block Changes (per second)
Database Block Changes (per transaction)
Database Block Gets (per second)
Database Block Gets (per transaction)
Database Time (centiseconds per second)
DBWR Checkpoints (per second)
Enqueue Deadlocks (per second)
Enqueue Deadlocks (per transaction)
Enqueue Requests (per second)
Enqueue Requests (per transaction)
Enqueue Timeout (per second)
Enqueue Timeout (per transaction)
Enqueue Waits (per second)
Enqueue Waits (per transaction)
Executes (per second)
Executes Performed without Parses (%)
Full Index Scans (per second)
Full Index Scans (per transaction)
Hard Parses (per second)
Hard Parses (per transaction)
I/O Megabytes (per second)
I/O Requests (per second)
Leaf Node Splits (per second)
Leaf Node Splits (per transaction)
Network Bytes (per second)
Number of Transactions (per second)
Open Cursors (per second)
Open Cursors (per transaction)
Parse Failure Count (per second)
Parse Failure Count (per transaction)
Physical Reads (per second)
Physical Reads (per transaction)
Physical Reads Direct (per second)
Physical Reads Direct (per transaction)
Physical Reads Direct Lobs (per second)
Physical Reads Direct Lobs (per transaction)
Physical Writes (per second)
Physical Writes (per transaction)
Physical Writes Direct (per second)
Physical Writes Direct (per transaction)
Physical Writes Direct Lobs (per second)
Physical Writes Direct Lobs (per transaction)
Recursive Calls (per second)
Recursive Calls (per transaction)
Redo Generated (per second)
Redo Generated (per transaction)
Redo Writes (per second)
Redo Writes (per transaction)
Rows Processed (per sort)
Scans on Long Tables (per second)
Scans on Long Tables (per transaction)
Session Logical Reads (per second)
Session Logical Reads (per transaction)
Soft Parse (%)
Sorts to Disk (per second)
Sorts to Disk (per transaction)
Total Index Scans (per second)
Total Index Scans (per transaction)
Total Parses (per second)
Total Parses (per transaction)
Total Table Scans (per second)
Total Table Scans (per transaction)
User Calls (%)
User Calls (per second)
User Calls (per transaction)
User Commits (per second)
User Commits (per transaction)
User Rollback Undo Records Applied (per second)
User Rollback Undo Records Applied (per transaction)
User Rollbacks (per second)
User Rollbacks (per transaction)

Ref.: http://docs.oracle.com/cd/E24628_01/em.121/e25160/oracle_database.htm#autoId411

Changes

Cause