{"id":91,"date":"2017-08-14T00:00:13","date_gmt":"2017-08-14T00:00:13","guid":{"rendered":"http:\/\/www.mrmarkyoung.com\/oracle\/?p=91"},"modified":"2017-08-14T00:00:13","modified_gmt":"2017-08-14T00:00:13","slug":"average-growth-over-the-past-6-months","status":"publish","type":"post","link":"http:\/\/www.mrmarkyoung.com\/oracle\/2017\/08\/14\/average-growth-over-the-past-6-months\/","title":{"rendered":"Average Growth Over the Past 6 Months"},"content":{"rendered":"\n<pre class=\"lang:default decode:true \" >with my_data AS (\r\n     select key_value2,\r\n     ROUND ((( (MAX (AVERAGE) - MIN (AVERAGE)))\/1024\/1024),2) as AVERAGE\r\n     from mgmt$metric_daily\r\n     where target_type = 'osm_cluster' and key_value like  'DATA%' and column_label = 'Total Bytes'\r\n     and rollup_timestamp &gt;= sysdate-182\r\n     group by key_value2\r\n     )\r\nselect * from my_data\r\npivot\r\n     (  AVG(AVERAGE)\r\n       for key_value2\r\n       IN ('ASM',\r\n'EILPRD1',\r\n'EILPRDDOV',\r\n'EILPRDSUN',\r\n'NEWDSS02DOV',\r\n'NEWDSS03PRD',\r\n'NEWDSSOAP01',\r\n'NEWDSSOAP04',\r\n'NEWSOA02DOV',\r\n'NEWSOAP01',\r\n'NEWSOAP04',\r\n'NEWTOLTTP01',\r\n'ORCDBAUZ01',\r\n'SBYDSS02DOV',\r\n'SBYDSS02PRD',\r\n'SBYDSS03PRD',\r\n'SBYDSSOAP01',\r\n'SBYSOA02SUN',\r\n'SBYSOAP01',\r\n'SBYSOAP042',\r\n'SBYTOLTTP01',\r\n'STBDSSOAP04',\r\n'WMPRD',\r\n'WMPRDDOV',\r\n'WMPRDSUN')\r\n);\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>with my_data AS ( select key_value2, ROUND ((( (MAX (AVERAGE) &#8211; MIN (AVERAGE)))\/1024\/1024),2) as AVERAGE from mgmt$metric_daily where target_type = &#8216;osm_cluster&#8217; and key_value like &#8216;DATA%&#8217; and column_label = &#8216;Total Bytes&#8217; and rollup_timestamp &gt;= sysdate-182 group by key_value2 ) select * from my_data pivot ( AVG(AVERAGE) for key_value2 IN (&#8216;ASM&#8217;, &#8216;EILPRD1&#8217;, &#8216;EILPRDDOV&#8217;, &#8216;EILPRDSUN&#8217;, &#8216;NEWDSS02DOV&#8217;, &#8216;NEWDSS03PRD&#8217;, &#8216;NEWDSSOAP01&#8217;, &#8230; <a title=\"Average Growth Over the Past 6 Months\" class=\"read-more\" href=\"http:\/\/www.mrmarkyoung.com\/oracle\/2017\/08\/14\/average-growth-over-the-past-6-months\/\" aria-label=\"Read more about Average Growth Over the Past 6 Months\">Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7],"tags":[13,17],"class_list":["post-91","post","type-post","status-publish","format-standard","hentry","category-enterprise-manager","tag-capacity","tag-growth"],"_links":{"self":[{"href":"http:\/\/www.mrmarkyoung.com\/oracle\/wp-json\/wp\/v2\/posts\/91","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.mrmarkyoung.com\/oracle\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.mrmarkyoung.com\/oracle\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.mrmarkyoung.com\/oracle\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.mrmarkyoung.com\/oracle\/wp-json\/wp\/v2\/comments?post=91"}],"version-history":[{"count":1,"href":"http:\/\/www.mrmarkyoung.com\/oracle\/wp-json\/wp\/v2\/posts\/91\/revisions"}],"predecessor-version":[{"id":92,"href":"http:\/\/www.mrmarkyoung.com\/oracle\/wp-json\/wp\/v2\/posts\/91\/revisions\/92"}],"wp:attachment":[{"href":"http:\/\/www.mrmarkyoung.com\/oracle\/wp-json\/wp\/v2\/media?parent=91"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.mrmarkyoung.com\/oracle\/wp-json\/wp\/v2\/categories?post=91"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.mrmarkyoung.com\/oracle\/wp-json\/wp\/v2\/tags?post=91"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}