{"id":89,"date":"2017-08-13T23:57:12","date_gmt":"2017-08-13T23:57:12","guid":{"rendered":"http:\/\/www.mrmarkyoung.com\/oracle\/?p=89"},"modified":"2017-08-13T23:57:12","modified_gmt":"2017-08-13T23:57:12","slug":"asm-pivot-data-diskgroup-total-bytes","status":"publish","type":"post","link":"http:\/\/www.mrmarkyoung.com\/oracle\/2017\/08\/13\/asm-pivot-data-diskgroup-total-bytes\/","title":{"rendered":"ASM Pivot data diskgroup Total Bytes"},"content":{"rendered":"\n<pre class=\"lang:default decode:true \" >with my_data AS (\r\n     select key_value2, rollup_timestamp, 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-14\r\n     )\r\nselect * from my_data\r\npivot\r\n     ( sum(average\/1024\/1024\/1024)\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\norder by rollup_timestamp;<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>with my_data AS ( select key_value2, rollup_timestamp, 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-14 ) select * from my_data pivot ( sum(average\/1024\/1024\/1024) 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;, &#8216;NEWDSSOAP04&#8217;, &#8216;NEWSOA02DOV&#8217;, &#8216;NEWSOAP01&#8217;, &#8216;NEWSOAP04&#8217;, &#8216;NEWTOLTTP01&#8217;, &#8216;ORCDBAUZ01&#8217;, &#8216;SBYDSS02DOV&#8217;, &#8216;SBYDSS02PRD&#8217;, &#8216;SBYDSS03PRD&#8217;, &#8216;SBYDSSOAP01&#8217;, &#8230; <a title=\"ASM Pivot data diskgroup Total Bytes\" class=\"read-more\" href=\"http:\/\/www.mrmarkyoung.com\/oracle\/2017\/08\/13\/asm-pivot-data-diskgroup-total-bytes\/\" aria-label=\"Read more about ASM Pivot data diskgroup Total Bytes\">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-89","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\/89","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=89"}],"version-history":[{"count":1,"href":"http:\/\/www.mrmarkyoung.com\/oracle\/wp-json\/wp\/v2\/posts\/89\/revisions"}],"predecessor-version":[{"id":90,"href":"http:\/\/www.mrmarkyoung.com\/oracle\/wp-json\/wp\/v2\/posts\/89\/revisions\/90"}],"wp:attachment":[{"href":"http:\/\/www.mrmarkyoung.com\/oracle\/wp-json\/wp\/v2\/media?parent=89"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.mrmarkyoung.com\/oracle\/wp-json\/wp\/v2\/categories?post=89"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.mrmarkyoung.com\/oracle\/wp-json\/wp\/v2\/tags?post=89"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}