EM 12c, EM 13c: How to run a SQL statement against the Enterprise Manager repository to show which metrics are being collected.
Last updated on DECEMBER 03, 2015
Applies to:Enterprise Manager for Oracle Database - Version 18.104.22.168.0 and later
Information in this document applies to any platform.
To use a SQL statement against the EM repository database which shows which metrics are collected for a particular target and to save in either html or excel format. This should show the same information as:
- Target Home Page
- 'Target type' (for example -Oracle Database) drop down menu
- Monitoring/Metric and Collection Settings
- View:All Metrics
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