Get the average growth over the past 12 months. Ensure you change the TARGET_GUID.<\/p>\n
SELECT\r\n (max(round(avg(a_size.size_gb),2)) - min(round(avg(a_size.size_gb),2)))\/12\r\nFROM\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 <= 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 <= sysdate\r\n GROUP BY m.metric_column, m.rollup_timestamp) used\r\nWHERE\r\n a_size.month_timestamp =used.month_timestamp\r\nGROUP BY TO_CHAR(a_size.month_timestamp,'MON RR');<\/pre>\n","protected":false},"excerpt":{"rendered":"Get the average growth over the past 12 months. Ensure you change the TARGET_GUID. SELECT (max(round(avg(a_size.size_gb),2)) – min(round(avg(a_size.size_gb),2)))\/12 FROM (SELECT m.rollup_timestamp AS month_timestamp, sum(m.average\/1024) AS size_gb FROM mgmt$metric_daily m, mgmt$target_type t WHERE t.target_guid=HEXTORAW(‘A06F734DEB35E1CFE38C9AB4729508E2′) AND (t.target_type=’rac_database’ OR (t.target_type=’oracle_database’ AND t.TYPE_QUALIFIER3 != ‘RACINST’)) AND m.target_guid=t.target_guid AND m.metric_guid=t.metric_guid AND t.metric_name=’tbspAllocation’ AND (t.metric_column=’spaceAllocated’) AND m.rollup_timestamp >= sysdate-365 AND m.rollup_timestamp … 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-80","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\/80","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=80"}],"version-history":[{"count":1,"href":"http:\/\/www.mrmarkyoung.com\/oracle\/wp-json\/wp\/v2\/posts\/80\/revisions"}],"predecessor-version":[{"id":81,"href":"http:\/\/www.mrmarkyoung.com\/oracle\/wp-json\/wp\/v2\/posts\/80\/revisions\/81"}],"wp:attachment":[{"href":"http:\/\/www.mrmarkyoung.com\/oracle\/wp-json\/wp\/v2\/media?parent=80"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.mrmarkyoung.com\/oracle\/wp-json\/wp\/v2\/categories?post=80"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.mrmarkyoung.com\/oracle\/wp-json\/wp\/v2\/tags?post=80"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}