Enterprise Manager Generic (MOSC)

MOSC Banner

Customized Metrics creation

edited Nov 12, 2016 4:00AM in Enterprise Manager Generic (MOSC) 3 commentsAnswered

I would like to create a customized metric for a database based on this SQL:

select max(a.value) as highest_open_cur

from v$sesstat a, v$statname b

where a.statistic# = b.statistic#

and b.name = 'opened cursors current';

Through EM, I have selected Database, Oracle Database, Monitoring, User_Defined Metrics, Custom Configuration Specification.  There I created a new configuration extension called "highest open cursor"

and deployed it to the database that I want to monitor.

The deployment was successful based on the job activity log.  However, I don't see it under the list of metrics for the database.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center