{"id":412,"date":"2021-02-26T08:23:36","date_gmt":"2021-02-25T22:23:36","guid":{"rendered":"http:\/\/www.mrmarkyoung.com\/oracle\/?p=412"},"modified":"2021-02-26T08:23:36","modified_gmt":"2021-02-25T22:23:36","slug":"average-growth-over-the-past-12-months","status":"publish","type":"post","link":"http:\/\/www.mrmarkyoung.com\/oracle\/2021\/02\/26\/average-growth-over-the-past-12-months\/","title":{"rendered":"Average growth over the past 12 months"},"content":{"rendered":"\n<pre class=\"wp-block-code\"><code>     SELECT\r\n       (max(round(avg(a_size.size_gb),2)) - min(round(avg(a_size.size_gb),2)))\/12\r\n     FROM\r\n      (SELECT  \r\n           m.rollup_timestamp AS month_timestamp,\r\n           sum(m.average\/1024) AS size_gb\r\n         FROM \r\n           mgmt$metric_daily m,\r\n           mgmt$target_type t\r\n         WHERE \r\n           t.target_guid=HEXTORAW('A06F734DEB35E1CFE38C9AB4729508E2') AND\r\n           (t.target_type='rac_database' OR \r\n           (t.target_type='oracle_database' AND t.TYPE_QUALIFIER3 != 'RACINST')) AND      \r\n           m.target_guid=t.target_guid AND\r\n           m.metric_guid=t.metric_guid AND\r\n           t.metric_name='tbspAllocation' AND\r\n           (t.metric_column='spaceAllocated') AND\r\n           m.rollup_timestamp >= sysdate-365 AND\r\n           m.rollup_timestamp &lt;= sysdate\r\n         GROUP BY m.metric_column, m.rollup_timestamp) a_size,\r\n       (SELECT  \r\n           m.rollup_timestamp AS month_timestamp,\r\n           sum(m.average\/1024) AS used_gb\r\n         FROM \r\n           mgmt$metric_daily m,\r\n           mgmt$target_type t\r\n         WHERE \r\n           t.target_guid=HEXTORAW('A06F734DEB35E1CFE38C9AB4729508E2') AND\r\n           (t.target_type='rac_database' OR \r\n           (t.target_type='oracle_database' AND t.TYPE_QUALIFIER3 != 'RACINST')) AND      \r\n           m.target_guid=t.target_guid AND\r\n           m.metric_guid=t.metric_guid AND\r\n           t.metric_name='tbspAllocation' AND\r\n           (t.metric_column='spaceUsed') AND\r\n           m.rollup_timestamp >= sysdate-365 AND\r\n           m.rollup_timestamp &lt;= sysdate\r\n         GROUP BY m.metric_column, m.rollup_timestamp) used\r\n     WHERE\r\n       a_size.month_timestamp =used.month_timestamp\r\n     GROUP BY TO_CHAR(a_size.month_timestamp,'MON RR');<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7],"tags":[],"class_list":["post-412","post","type-post","status-publish","format-standard","hentry","category-enterprise-manager"],"_links":{"self":[{"href":"http:\/\/www.mrmarkyoung.com\/oracle\/wp-json\/wp\/v2\/posts\/412","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=412"}],"version-history":[{"count":1,"href":"http:\/\/www.mrmarkyoung.com\/oracle\/wp-json\/wp\/v2\/posts\/412\/revisions"}],"predecessor-version":[{"id":413,"href":"http:\/\/www.mrmarkyoung.com\/oracle\/wp-json\/wp\/v2\/posts\/412\/revisions\/413"}],"wp:attachment":[{"href":"http:\/\/www.mrmarkyoung.com\/oracle\/wp-json\/wp\/v2\/media?parent=412"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.mrmarkyoung.com\/oracle\/wp-json\/wp\/v2\/categories?post=412"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.mrmarkyoung.com\/oracle\/wp-json\/wp\/v2\/tags?post=412"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}