Customized Metrics creation
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.