This content has been marked as final. Show 8 replies
You can get the metric names from the repository from mgmt_metrics table.
Connect to repository db as sysman and you can query the mgmt_metrics table to get the metric name from the column mgmt_name.
I checked the MGMT-Tables but I didn't find any column called mgmt_name. I also searched the whole DB for the column name without any result.
SQL> select owner, column_name from dba_tab_columns where column_name like 'MGMT_%'
No result for MGMT_NAME
Do you have any further suggestions where I can find the metric names? We use OEM 12c BP1 maybe thats the reason why I can't find the column.
Look at the METRIC_NAME column in the MGMT$METRIC_COLLECTION view.
Can we get the same metric name displayed in the console of EM in the repository as well?
Yes, the metric name can be retrieved from column METRIC_NAME.
The metric names displayed over the console will not be same as that was in repository.
emctl status agent scheduler
You can query gc_metric_groups view to obtain metric group name. Metric group name can be used as METRICNAME in the emctl command.