My Oracle Support Banner

EM 13c, EM 12c: How to Prevent Alerts from the Server Adaptive Threshold Metric (Server_Adaptive_Threshold_Metric) (Doc ID 1929003.1)

Last updated on DECEMBER 03, 2021

Applies to:

Enterprise Manager for Oracle Database - Version and later
Information in this document applies to any platform.


To prevent alerts from the 'Server Adaptive Threshold' metric in Enterprise Manager (EM) Cloud Control.  
An example of an email alert from the server_adaptive_threshold_metric:

Host=<host name>
Target type=Database Instance
Target name=<instance name>
Message=Metrics "Physical Writes Per Sec" is at 2.449
Event reported time=Sep 23, 2014 2:23:01 PM BST
Operating System=Linux
Associated Incident Id=7262
Associated Incident Status=New
Associated Incident Owner=
Associated Incident Acknowledged By Owner=No
Associated Incident Priority=None
Associated Incident Escalation Level=0
Event Type=Metric Alert
Event name=Server_Adaptive_Threshold_Metric:instance_throughput__physwrites_ps
Metric Group=Server_Adaptive_Threshold_Metric
Metric=Physical Writes Per Sec
Metric value=2.44918360546485
Key Value=SYSTEM
Rule Owner=
Update Details:
Metrics "Physical Writes Per Sec" is at 2.449
Incident created by rule (Name = Incident management rule set for all targets, Create incident for critical metric alerts [System generated rule]).

An example of the alert in incident manager:


There have been some changes to the way that metrics are evaluated in Cloud Control (when used in conjunction with the or higher database plug-in).  The biggest change is that most metrics which were previously evaluated by the server generated alert system (in older versions of Enterprise Manager) will now be evaluated purely by the agent.   In and higher the new behaviour is that all metrics where it is possible to set a threshold (via the 'metric and collection settings' screen) will be evaluated by the agent and the server generated alert system is no longer relied on.  See <Note 1680788.1> "EM 12c, EM 13c: Changes to Oracle Database Monitoring in Enterprise Manager Cloud Control and later with DB-Plugin and later" which explains this further.   

The 'server adaptive threshold' metric is *not* one of the metrics which uses the 'new behavior'.  It is not possible to set thresholds for the 'server adaptive threshold metric' in Enterprise Manager's 'metric and collection settings' screen nor is it possible to disable this metric via the EM interface.  This means that the 'server adaptive threshold' metric will still be evaluated via the server generated alert system and will generate an alert according to the thresholds which are set in sys.dba_thresholds on the database.  

Please note that the server adaptive threshold metric has been provided for backwards compatibility only for customers who need to continue to utilize the server generated alert system for database adaptive threshold metrics. However, EM and higher also provides a new "Adaptive Threshold" mechanism, which is controlled by the Enterprise Manager metric alert subsystem and which does not rely on the server generated alert system or the settings in sys.dba_thresholds.  This is the preferred method to be used when working with adaptive thresholds (thresholds which are not set statically but which self modify over time according to user specifications).  These new adaptive thresholds features can be found under Advanced Threshold Management and can be accessed as follows:

  • Database Home Page Oracle Database pull-down menu
  • Monitoring /Metric and Collection Settings
  • scroll down to Related Links/Advanced Threshold Management
It is recommended that these new 'adaptive threshold management/adaptive metrics ' be used instead of relying on the 'server adaptive threshold metric'.  For example, it is possible to create a monitoring template which sets the 'advanced threshold management/adaptive metrics' .  It is not possible to create a monitoring template based on the 'server adaptive threshold metric' because the thresholds are not controlled by 'metric and collection settings' page, but are set individually for each database.

The 'server adaptive threshold' metric will fire when the thresholds are crossed which are set on the database itself (in sys.dba_thresholds).   This means that if any of the following metrics, have thresholds set in sys.dba_thresholds, the server adaptive threshold metric could fire if the thresholds are crossed:-

Average Active Sessions, Average Synchronous Single Block Read Latency (ms), CPU Usage Per Txn, Cumulative Logons Per Sec, Cumulative Logons Per Txn, Current Logons Count, Current Open Cursors Count, DBWR Checkpoints Per Sec, Database Block Changes Per Txn, Enqueue Requests Per Txn, Executes Per Sec, Global Cache Average CR Block Request Time (centi-seconds), Global Cache Average, current Block Request Time (centi-seconds), Hard Parses Per Sec, I/O Megabytes Per Sec, I/O Requests Per Sec, Network Bytes Per Sec, Number of Transactions Per Sec, Parallel Execution Downgraded Per Sec, Parallel Execution Downgraded to Serial Per Sec, Physical reads Per Sec, Physical Reads per TXN, Physical Writes per sec, physical writes per txn, physical writes per txn, recursive calls per sec, recursive calls per txn, redo generated per sec, redo generated per txn, redo writes per txn, response time (centi-seconds per call), response time per txn, rows processed (per sort), scans on long tables per sec , scans on long tables per txn, session logical reads per sec, session logical reads per txn, sorts to disk per txn, total parses per sec, total parses per txn, totaltable scans per sec, total table scans per txn, user calls per sec, user calls per txn, user commits per sec, user commits per txn, user rollbacks per sec, user rollbacks per txn.

For a database which is newly added to EM Cloud Control it is likely that the thresholds will not be set on the database in sys.dba_thresholds for these metrics.  This is because EM provides a different set of metrics (mostly under 'Throughput')  For example:

Throughput/Average Active Sessions
Throughput/Physical Reads Per Sec 

To see the full list, go to 

Throughput metrics which can be set like this from the "metric and collection settings" page, will not update the thresholds in sys.dba_thresholds because they will be evaluated purely by the Agent.
If it is required to utilize the 'server adaptive threshold' metric (for backwards compatibility purposes), then the thresholds should be set as follows:
  • Go to database home page/performance/adaptive thresholds
  • locate the metric, click on Edit Thresholds
  • Setting the thresholds in this way, will update sys.dba_thresholds.

How this metric can be influenced by older Enterprise Manager products

In previous versions of Enterprise Manager, if the throughput metric was set (for example), this relied on the server generated alert system.  This means that in previous versions of the product, setting a 'throughput' metric would have updated the sys.dba_thresholds on the database.  It is possible therefore, that if the database is also being monitored by an alternative agent (eg. dbconsole agent component, earlier version of Cloud Control agent, or Grid control agent), that the thresholds in sys.dba_thresholds could be set (by the other 'old' EM agent).   It is also possible that if EM has been updated from 12.1.0.x to (or higher), that some of the databases monitored may have had metrics set which will have modified sys.dba_thresholds on the database.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
 How this metric can be influenced by older Enterprise Manager products
 a) Check whether any adaptive thresholds are configured on the database
 b) Remove the adaptive and static thresholds
 c) Confirm that the adaptive threshold has been removed in dbsnmp.bsln_threshold_params (adaptive thresholds only)
 d) Confirm that that the thresholds are removed from dba_thresholds
 e) Alternatively, the thresholds can be removed from dbms_server_alert package.

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.