{"id":5020,"date":"2015-11-25T10:07:59","date_gmt":"2015-11-25T09:07:59","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/querying-the-oracle-management-repository\/"},"modified":"2015-11-25T10:07:59","modified_gmt":"2015-11-25T09:07:59","slug":"querying-the-oracle-management-repository","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/querying-the-oracle-management-repository\/","title":{"rendered":"Querying the Oracle Management Repository"},"content":{"rendered":"<pre class=\"brush: actionscript3; gutter: false; first-line: 1\"><\/pre>\n<p>The Enterprise Manager Cloud Control 12c is an amazing tool allowing the DBA to display a lot of informations from the console . But there are also a lot of repository views that may be consulted by the DBA to build a lot of various reports.<\/p>\n<p>The Oracle Management Service collects a huge amount of raw data from the agents installed on each managed host you administer with EM 12c.<\/p>\n<p>Those raw data are inserted in various tables like EM_METRIC_VALUES for example. Enterprise Manager aggregates those management data by hour and by day. Those raw data are kept 7 days; the one hour aggregated data are kept 31 days, while one day aggregated data are kept one year.<\/p>\n<p>A good way to get information in the Oracle Management Repository is to build queries against the GC%METRIC% views. The GC_METRIC% views are built from EM_METRIC_VALUES. EM_METRIC_ITEMS and EM_METRIC_KEYS tables and the GC$METRIC% views are built from the GC_METRIC% views. There are a lot of GC%METRIC% views :<\/p>\n<pre class=\"brush: sql; gutter: false; first-line: 1\">SQL&gt; select distinct view_name from user_views where view_name like 'GC%METRIC%' order by 1;<\/pre>\n<pre class=\"brush: actionscript3; gutter: false; first-line: 1\">GC$METRIC_CATEGORIES\nGC$METRIC_COLUMNS\nGC$METRIC_COLUMNS_TARGET \nGC$METRIC_ERROR_CURRENT\nGC$METRIC_ERROR_HISTORY\nGC$METRIC_GROUPS\nGC$METRIC_GROUPS_TARGET\n$METRIC_KEYS\nGC$METRIC_LATEST\nGC$METRIC_STR_VALUES\nGC$METRIC_STR_VALUES_LATEST\nGC$METRIC_VALUES\nGC$METRIC_VALUES_DAILY\nGC$METRIC_VALUES_HOURLY\nGC$METRIC_VALUES_LATEST\nGC$TARGET_METRIC_COLLECTIONS\nGC_METRIC_COLLECTIONS\nGC_METRIC_COLUMNS\nGC_METRIC_COLUMNS_TARGET\nGC_METRIC_COMPOSITE_KEYS\nGC_METRIC_GROUPS\nGC_METRIC_GROUPS_TARGET\nGC_METRIC_KEYS\nGC_METRIC_LATEST\nGC_METRIC_LATEST_WO_TGT\nGC_METRIC_STATS_METRIC\nGC_METRIC_STATS_METRIC_DAILY\nGC_METRIC_STATS_TARGET\nGC_METRIC_STATS_TARGET_DAILY\nGC_METRIC_STR_VALUES\nGC_METRIC_STR_VALUES_LATEST\nGC_METRIC_STR_VALUES_WO_TGT\nGC_METRIC_THRESHOLDS\nGC_METRIC_VALUES\nGC_METRIC_VALUES_DAILY\nGC_METRIC_VALUES_HOURLY\nGC_METRIC_VALUES_LATEST\nGC_METRIC_VAL_HOURLY_WO_TGT\nGC_RAT_TRIAL_METRIC_VALUES\nGC_RAT_TRIAL_TARGET_METRICS<\/pre>\n<p>For example if we are interested by the load for a host, you can use the console:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/qomr1.png\" alt=\"qomr1\" width=\"248\" height=\"272\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>You can also find this information by querying the OMR in the view gc$metric_columns for an entity of type host and a metric_group_label of type Load:<\/p>\n<pre class=\"brush: actionscript3; gutter: false; first-line: 1\">SQL&gt; select entity_type,metric_column_label,metric_group_label\nfrom gc$metric_columns\nwhere entity_type = 'host'\nand metric_group_label = 'Load';<\/pre>\n<p>&nbsp;<\/p>\n<pre class=\"brush: sql; gutter: false; first-line: 1\">host\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Active Logical Memory, Kilobytes\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Load\nhost\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Active Memory, Kilobytes\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Load\nhost\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 CPU Interrupt Time (%)\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Load\nhost\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 CPU Queue Length\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Load\nhost\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 CPU Utilization (%)\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Load\nhost\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 CPU in I\/O Wait (%)\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Load\nhost\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 CPU in System Mode (%)\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Load\nhost\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 CPU in User Mode (%)\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Load\nhost\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Free Memory (%)\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Load\nhost\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Free Memory, Kilobytes\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Load\nhost\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Logical Free Memory (%)\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Load\nhost\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Memory Page Scan Rate (per second)\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Load\nhost\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Memory Utilization (%)\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Load\nhost\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Page Transfers Rate\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Load\nhost\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Run Queue Length (1 minute average,per core)\u00a0 Load\nhost\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Run Queue Length (15 minute average,per core) Load\nhost\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Run Queue Length (5 minute average,per core)\u00a0 Load\nhost\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Swap Free (KB)\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Load\nhost\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Swap Utilization (%)\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Load\nhost\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Swap Utilization, Kilobytes\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Load\nhost\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Total Processes\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0  Load\nhost\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Total Users\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Load\n\n<\/pre>\n<p>We can sort the metrics collected by entity type for example host :<\/p>\n<pre class=\"brush: actionscript3; gutter: false; first-line: 1\">SQL&gt; select entity_type,metric_group_label\nfrom gc$metric_columns\nwhere entity_type = 'host'\ngroup by entity_type,metric_group_label\norder by 1,2;<\/pre>\n<pre class=\"brush: sql; gutter: false; first-line: 1\">host\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 All Processes\nhost\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Battery details\nhost\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Buffer Activity\nhost\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 CCCAppFileParser\nhost\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 CCCData_base\nhost\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 CCCData_group\nhost\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 CCCData_mapping\nhost\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 CCCData_obs\nhost\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 CCCData_queue\nhost\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 CCCData_warning\nhost\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 CCCWatchdog\nhost\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0 CPU Usage\nhost\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 CPU Usage Internal\nhost\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 CPUs Details\nhost\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Compute Node Temperature\nhost\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 DiscoverNow\n\u2026.\n\nOr an oracle database:<\/pre>\n<pre class=\"brush: actionscript3; gutter: false; first-line: 1\">SQL&gt; select entity_type,metric_group_label\nfrom gc$metric_columns\nwhere entity_type = 'oracle_database'\ngroup by entity_type,metric_group_label\norder by 1,2;\n\noracle_database\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ADDM Report - Global\noracle_database\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ALL Privileges\noracle_database\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ANY Privileges\noracle_database\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Access To Important Tables And Views\noracle_database\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Active Sessions by CPU and Wait Classes\noracle_database\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Alert Log\noracle_database\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Alert Log Content\noracle_database\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Alert Log Error Status\noracle_database\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Archive Area\noracle_database\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Archive Area - RAC Instance\noracle_database\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Audit Settings\noracle_database\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Audit Syslog Level\noracle_database\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 AutoTask Client\noracle_database\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 CPU Usage\noracle_database\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Collect SQL Response Time\noracle_database\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Connect Role\noracle_database\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Control files\noracle_database\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 DB Alert Log\noracle_database\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 DB Audit Files Permissions\noracle_database\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 DB Control Files Permission\noracle_database\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 DB Data Files Permissions\noracle_database\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 DB InitParameter File Permissions\noracle_database\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 DB Link Usage\noracle_database\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 DB Password Setting\noracle_database\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 DB Profile Setting\noracle_database\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 DB Scheduler Jobs\noracle_database\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 DBA Group Assignment\noracle_database\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 DGPrimaryDBName\noracle_database\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Data Base parameter collection\noracle_database\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Data Failure\noracle_database\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Data Guard - 10.1 Database\noracle_database\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Data Guard - 9.2 Database\noracle_database\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Data Guard Failover\noracle_database\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Data Guard Fast-Start Failover\noracle_database\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Data Guard Fast-Start Failover Observer<\/pre>\n<pre class=\"brush: shell; gutter: false; first-line: 1\"><\/pre>\n<p>So the main interest is to collect data from those views, for example we can look more precisely in the CPU consumption for a host:<\/p>\n<pre class=\"brush: actionscript3; gutter: false; first-line: 1\">SQL&gt; select entity_name ,collection_time,min_value as min,avg_value as avg,max_value as max\nfrom gc$metric_values_daily\nwhere metric_group_name = 'Load'\nand metric_column_name = 'cpuUtil'\nand (entity_name like '%dbserver1%' )\norder by 2,1 asc;<\/pre>\n<pre class=\"brush: sql; gutter: false; first-line: 1\">Entity_name \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0collection_time\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0min \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0avg\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0max\ndbserver1.localdomain\u00a0 \u00a0 \u00a0 \u00a0\u00a0 01-JUN-15\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0 \u00a0 \u00a0 3.782\u00a0\u00a0\u00a0\u00a0\u00a0\u00a017.4089931\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a072.284\ndbserver1.localdomain\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 02-JUN-15\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a02.788 \u00a0\u00a0\u00a0\u00a0\u00a011.3085764\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a038.61\ndbserver1.localdomain\u00a0 \u00a0 \u00a0 \u00a0\u00a0 03-JUN-15\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a04.16\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 11.7149271\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a028.975\ndbserver1.localdomain\u00a0 \u00a0 \u00a0 \u00a0\u00a0 04-JUN-15\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a05.526\u00a0\u00a0\u00a0\u00a0\u00a0\u00a011.6824271\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a029.451\ndbserver1.localdomain\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 05-JUN-1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a05.337\u00a0\u00a0\u00a0\u00a0\u00a0\u00a010.9915486\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a027.319\ndbserver1.localdomain\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 06-JUN-15\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a05.664\u00a0\u00a0\u00a0\u00a0\u00a0\u00a016.7499653\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a045.798\ndbserver1.localdomain\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 07-JUN-15\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a05.021\u00a0\u00a0\u00a0\u00a0\u00a0\u00a015.4098958\u00a0 \u00a0 \u00a0 \u00a084.75\ndbserver1.localdomain\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 08-JUN-15\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a04.664\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a09.7744375\u00a0 \u00a0 \u00a0 \u00a028.159\ndbserver1.localdomain\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 09-JUN-15\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a04.79\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a09.4026805\u00a0\u00a0\u00a0\u00a0\u00a0  21.113\ndbserver1.localdomain\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 10-JUN-15\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a05.17\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a09.5937881\u00a0\u00a0\u00a0\u00a0\u00a0  31.238\ndbserver1.localdomain\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 11-JUN-15\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0 \u00a0 \u00a0 5.162\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a08.8185104\u00a0\u00a0\u00a0\u00a0   16.562\ndbserver1.localdomain\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 12-JUN-15\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a05.666\u00a0\u00a0\u00a0\u00a0\u00a0\u00a011.0074132\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 33.058\ndbserver1.localdomain\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 13-JUN-15\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a06.412\u00a0\u00a0\u00a0\u00a0\u00a0\u00a015.4432917\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 42.709\ndbserver1.localdomain\u00a0 \u00a0 \u00a0 \u00a0\u00a0 14-JUN-15\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a05.897\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a09.6474548\u00a0\u00a0\u00a0\u00a0\u00a0  40.575\ndbserver1.localdomain\u00a0 \u00a0 \u00a0 \u00a0\u00a0 15-JUN-15\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a05.675\u00a0\u00a0\u00a0\u00a0\u00a0\u00a014.5982083\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 34.483<\/pre>\n<p>&nbsp;<\/p>\n<p>For a more precise measure you can select on gc$metric_values_hourly:<\/p>\n<pre class=\"brush: actionscript3; gutter: false; first-line: 1\">SQL&gt; select entity_name,collection_time,min_value as min,avg_value as avg,max_value as max\nfrom gc$metric_values_hourly\nwhere metric_group_name = 'Load'\nand metric_column_name = 'cpuUtil'\nand (entity_name like 'dbserver1%' )\norder by 1,2\n\/<\/pre>\n<p>&nbsp;<\/p>\n<pre class=\"brush: html; gutter: false; first-line: 1\">Entity_name \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0collection_time\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0 min \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0avg\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0 max\n\u2026.\ndbserver1.localdomain\u00a0\u00a0 15-JUN-15 14:00:00\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a015.23\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0  18.65\u00a0\u00a0\u00a0\u00a0 22.025\ndbserver1.localdomain\u00a0\u00a0 15-JUN-15 15:00:00\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 7.844\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a09.17\u00a0\u00a0\u00a0\u00a0 11.406\ndbserver1.localdomain\u00a0\u00a0 15-JUN-15 16:00:00\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a08.635\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a010.76\u00a0\u00a0\u00a0\u00a0 13.625\ndbserver1.localdomain\u00a0\u00a0 15-JUN-15 17:00:00\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a07.928\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a09.57\u00a0\u00a0\u00a0\u00a0 16.607\ndbserver1.localdomain\u00a0\u00a0 15-JUN-15 18:00:00\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a08.439\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a013.39\u00a0\u00a0   21.518\ndbserver1.localdomain\u00a0\u00a0 15-JUN-15 19:00:00\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a07.722\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a010.56\u00a0\u00a0\u00a0\u00a0 14.767\ndbserver1.localdomain\u00a0\u00a0 15-JUN-15 20:00:00\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a07.993\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a09.09\u00a0\u00a0\u00a0\u00a0 12.934\ndbserver1.localdomain\u00a0\u00a0 15-JUN-15 21:00:00\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a07.449\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a09.20\u00a0\u00a0\u00a0\u00a0 12.2\ndbserver1.localdomain\u00a0\u00a0 15-JUN-15 22:00:00\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a08.001\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a010.47\u00a0\u00a0\u00a0\u00a0 16.328\ndbserver1.localdomain\u00a0\u00a0 15-JUN-15 23:00:00\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a07.366\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a08.77\u00a0\u00a0\u00a0\u00a0 14.51\n\u2026.<\/pre>\n<p>We can also display those values in the EM12c console:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/qomr2.png\" alt=\"qomr2\" width=\"605\" height=\"153\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>Thus there are great possibilities to query the gc$metric_values% views in order to build reports. For example if we look at the different metric_group_label for an oracle database entity:<\/p>\n<pre class=\"brush: actionscript3; gutter: false; first-line: 1\">SQL&gt; select distinct metric_group_label from gc$metric_values_daily\n2   where entity_type = 'oracle_database' order by 1;<\/pre>\n<pre class=\"brush: sql; gutter: false; first-line: 1\">Alert Log Error Status\nArchive Area\nCPU Usage\nDatabase Job Status\nDatabase Limits\nDatabase Size\nDeferred Transactions\nDump Area\nEfficiency\nFlash Recovery\nGlobal Cache Statistics\nInterconnect Traffic\nInvalid Objects by Schema\nMemory Usage\nMessages per buffered queue\nMessages per buffered queue per subscriber\nMessages per persistent queue\nMessages per persistent queue per subscriber\nOCM Instrumentation\nOptimal SGA\nPGA Allocated\nRecovery Area\nResponse\nSCN Growth Statistics\nSCN Instance Statistics\nSCN Max Statistics\nSGA Pool Wastage\nSegment Advisor Recommendations\nSpace usage by buffered queues\nSystem Response Time Per Call\nTablespace Allocation\nTablespaces Full\nThroughput\nUser Audit\nUser Block\nUser Locks\nWait Bottlenecks\nWaits by Wait Class\nbackup_archive_log_age\ndatafile_backup\nflashback available\nincident_meter\nmax number of datafiles<\/pre>\n<p>&nbsp;<\/p>\n<p>Then we can ask for more precise measures:<\/p>\n<pre class=\"brush: actionscript3; gutter: false; first-line: 1\">SQL&gt; select distinct key_part_1 from gc$metric_values_daily \nwhere metric_group_name = 'wait_sess_cls' \norder by 1;<\/pre>\n<pre class=\"brush: html; gutter: false; first-line: 1\">Administrative\nApplication\nCluster\nCommit\nConcurrency\nConfiguration\nIdle\nNetwork\nOther\nQueueing\nScheduler\nSystem I\/O\nUser I\/O<\/pre>\n<p>&nbsp;<\/p>\n<p>And we can write a SQL request to analyse the User I\/O wait:<\/p>\n<pre class=\"brush: actionscript3; gutter: false; first-line: 1\">SQL&gt; select collection_time,\nmin_value as min_wait ,\navg_value as avg_wait ,\nmax_value as max_wait\nfrom gc$metric_values_daily\nwhere metric_group_name = 'wait_sess_cls'\nand metric_column_name = 'dbtime_waitclass_pct'\nand (entity_name like 'dbserver1%' )\nand key_part_1 = 'User I\/O'\norder by 1,2 asc;<\/pre>\n<p>&nbsp;<\/p>\n<pre class=\"brush: html; gutter: false; first-line: 1\">Collection_time\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0min_wait\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0avg_wait\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0max_wait\n01-JUN-15 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0.190094016\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 45.7777238\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 86.9431254\n02-JUN-15 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0.026723742\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 49.4623178\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 98.6886502\n03-JUN-15\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0.09020789\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 32.6063701\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 98.7430495\n04-JUN-15 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0 .066328202\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 26.342438\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 97.1319971\n05-JUN-15\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0.032959651\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 22.7424382\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 96.1533236\n06-JUN-15\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0.574570414\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 22.2140084\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 93.9315499\n07-JUN-15\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0 .022970399\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 20.6773665 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 88.9020253\n08-JUN-15\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0.058117038\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 17.5328715\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 98.5629756\n09-JUN-15\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0.080441214\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 20.5507072\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 98.4615166\n10-JUN-15\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0.057529812\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 19.1080933\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 97.4292408\n11-JUN-15\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0.038726475\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 21.6932703\u00a0 \u00a0 \u00a0 \u00a0 96.48269\n12-JUN-15\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0.106343267\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 25.0541945\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 89.5404451\n13-JUN-15 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0.257816863\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 13.5371153\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 80.1841142\n14-JUN-15\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0.004258955\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 16.5949771\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 84.7824337\n15-JUN-15\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0.020058791\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 19.1270265\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 89.8952919<\/pre>\n<p>&nbsp;<\/p>\n<p>Naturally we find back those I\/O values in the EM12c console:<\/p>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/qomr3.png\" alt=\"qomr3\" width=\"753\" height=\"313\" \/><\/p>\n<p>Conclusion: querying the OMR views might allow Oracle DBA to build interesting reports on Hosts and Databases activities.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>The Enterprise Manager Cloud Control 12c is an amazing tool allowing the DBA to display a lot of informations from the console . But there are also a lot of repository views that may be consulted by the DBA to build a lot of various reports. The Oracle Management Service collects a huge amount of [&hellip;]<\/p>\n","protected":false},"author":27,"featured_media":5021,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[198],"tags":[218],"type_dbi":[],"class_list":["post-5020","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database-management","tag-oracle-enterprise-manager-cloud-12c"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.2 (Yoast SEO v27.4) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Querying the Oracle Management Repository - dbi Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dbi-services.com\/blog\/querying-the-oracle-management-repository\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Querying the Oracle Management Repository\" \/>\n<meta property=\"og:description\" content=\"The Enterprise Manager Cloud Control 12c is an amazing tool allowing the DBA to display a lot of informations from the console . But there are also a lot of repository views that may be consulted by the DBA to build a lot of various reports. The Oracle Management Service collects a huge amount of [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/querying-the-oracle-management-repository\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2015-11-25T09:07:59+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/qomr1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"248\" \/>\n\t<meta property=\"og:image:height\" content=\"272\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Oracle Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Oracle Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/querying-the-oracle-management-repository\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/querying-the-oracle-management-repository\\\/\"},\"author\":{\"name\":\"Oracle Team\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/66ab87129f2d357f09971bc7936a77ee\"},\"headline\":\"Querying the Oracle Management Repository\",\"datePublished\":\"2015-11-25T09:07:59+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/querying-the-oracle-management-repository\\\/\"},\"wordCount\":384,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/querying-the-oracle-management-repository\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/qomr1.png\",\"keywords\":[\"Oracle Enterprise Manager Cloud 12c\"],\"articleSection\":[\"Database management\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/querying-the-oracle-management-repository\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/querying-the-oracle-management-repository\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/querying-the-oracle-management-repository\\\/\",\"name\":\"Querying the Oracle Management Repository - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/querying-the-oracle-management-repository\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/querying-the-oracle-management-repository\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/qomr1.png\",\"datePublished\":\"2015-11-25T09:07:59+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/66ab87129f2d357f09971bc7936a77ee\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/querying-the-oracle-management-repository\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/querying-the-oracle-management-repository\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/querying-the-oracle-management-repository\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/qomr1.png\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/qomr1.png\",\"width\":248,\"height\":272},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/querying-the-oracle-management-repository\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Querying the Oracle Management Repository\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/66ab87129f2d357f09971bc7936a77ee\",\"name\":\"Oracle Team\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"caption\":\"Oracle Team\"},\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/author\\\/oracle-team\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Querying the Oracle Management Repository - dbi Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.dbi-services.com\/blog\/querying-the-oracle-management-repository\/","og_locale":"en_US","og_type":"article","og_title":"Querying the Oracle Management Repository","og_description":"The Enterprise Manager Cloud Control 12c is an amazing tool allowing the DBA to display a lot of informations from the console . But there are also a lot of repository views that may be consulted by the DBA to build a lot of various reports. The Oracle Management Service collects a huge amount of [&hellip;]","og_url":"https:\/\/www.dbi-services.com\/blog\/querying-the-oracle-management-repository\/","og_site_name":"dbi Blog","article_published_time":"2015-11-25T09:07:59+00:00","og_image":[{"width":248,"height":272,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/qomr1.png","type":"image\/png"}],"author":"Oracle Team","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Oracle Team","Est. reading time":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/querying-the-oracle-management-repository\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/querying-the-oracle-management-repository\/"},"author":{"name":"Oracle Team","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"headline":"Querying the Oracle Management Repository","datePublished":"2015-11-25T09:07:59+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/querying-the-oracle-management-repository\/"},"wordCount":384,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/querying-the-oracle-management-repository\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/qomr1.png","keywords":["Oracle Enterprise Manager Cloud 12c"],"articleSection":["Database management"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/querying-the-oracle-management-repository\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/querying-the-oracle-management-repository\/","url":"https:\/\/www.dbi-services.com\/blog\/querying-the-oracle-management-repository\/","name":"Querying the Oracle Management Repository - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/querying-the-oracle-management-repository\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/querying-the-oracle-management-repository\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/qomr1.png","datePublished":"2015-11-25T09:07:59+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/querying-the-oracle-management-repository\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/querying-the-oracle-management-repository\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/querying-the-oracle-management-repository\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/qomr1.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/qomr1.png","width":248,"height":272},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/querying-the-oracle-management-repository\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Querying the Oracle Management Repository"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee","name":"Oracle Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","caption":"Oracle Team"},"url":"https:\/\/www.dbi-services.com\/blog\/author\/oracle-team\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/5020","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/27"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=5020"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/5020\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/5021"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=5020"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=5020"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=5020"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=5020"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}