EM 12C: How to Disable the Metric Current Open Cursors Count Metric for an Oracle Database Target in Enterprise Manager 12c Cloud Control and on the Database (Doc ID 1968511.1)

Last updated on FEBRUARY 06, 2017

Applies to:

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

Goal

Current Open Cursors Count is a sever generated metric (this metric has the same behavior as the Tablespace Full % metric). Once triggered, the alert is generated on the database and subsequently pushed to Enterprise Manager, which sends a notification e-mail. The following documents explain  server generated alerts:

<Note 1928592.1> Understanding the role of the Server Generated Alert System in the evaluation of the Tablespace Space Full (%) metric in Enterprise Manager 12c Cloud Control and Grid Control

<Note 266970.1> Understanding Oracle 10G - Server Generated Alerts
This  document is valid for 11.1 and 11.2 databases.

When server generated metrics are disabled from EM 12c, the DBMS_SERVER_ALERT.SET_THRESHOLD package is run in the target database to disable the metric on the database server. In certain circumstances, it has been observed that when the metric is disabled from EM 12c, the metric is not disabled on the database. The workaround, to avoid the troublesome notifications, is to directly run the DBMS_SERVER_ALERT.SET_THRESHOLD package on the target databases (the user can also DEBUG the metric reporting action to check why thresholds are not propagated to the target database). See the following reference for a description of this known issue:

<Note 1604806.1> EM Send Alerts Without Thresholds for Server Generated Alerts like (Tablespace Used% ,Redo Generated Per Sec, Average Active Sessions,Response Time Per Txn etc)

This document describes the same behavior on a different metric, and the principle also applies to Current Open Cursors Count.
 

Solution

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms