EM13: Performance issue querying SYSMAN.GC_METRIC_STR_VALUES
From: Rich J <rjoralist3_at_society.servebeer.com>
Date: Thu, 23 Aug 2018 11:53:40 -0500
Message-ID: <5e691520548567cf2272e85add2747f1_at_society.servebeer.com>
Hey all,
Date: Thu, 23 Aug 2018 11:53:40 -0500
Message-ID: <5e691520548567cf2272e85add2747f1_at_society.servebeer.com>
Hey all,
I have a Metric Extension in EM 13.2.0.0.0 whose values are strings. But querying the SYSMAN.GC_METRIC_STR_VALUES view on the 12.2.0.1.0 OMS is very slow, taking 2 minutes to return the first 500 rows from the simple cursor:
SELECT * FROM SYSMAN.GC_METRIC_STR_VALUES When trying to return metric values in past versions of EM, I've filtered the queries with various columns like:
SELECT
*
FROM
sysman.gc_metric_str_values
WHERE
entity_type = 'oracle_database'
AND entity_name = 'myoradb' AND entity_guid = '8C686DE17F33936EAFB49CA9AE1A0E6D' AND metric_group_name = 'ME$myext' AND metric_column_name = ('fun_text') AND metric_column_guid = '6C80A9B8B5A3AD57D9412874F5B0BB2D'
Still no joy. Since Oracle locks the stats on the SYSMAN schema, I've spent some time pulling apart the (many!) underlying views and tables,
but bypassing the view seems like it could a maintenance issue for EM upgrades.Has anyone else seen poor performance on this view?
TIA,
Rich
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Aug 23 2018 - 18:53:40 CEST