Database Size (1)

select a.DTTM 
     , trim(substr(a.target_name, instr(a.target_name,'.')+1,20)) HOST_NAME
     , trim(substr(a.target_name, 1, instr(a.target_name,'.')-1)) DATABASE
     , ALLOC_GB
     , USED_GB
  FROM (SELECT TARGET_NAME 
             , TO_CHAR(ROLLUP_TIMESTAMP,'YYYY-MM-DD') DTTM
             , TO_CHAR(MAX(AVERAGE),'999999.99') USED_GB
          FROM MGMT$METRIC_DAILY 
         WHERE METRIC_NAME = 'DATABASE_SIZE'
           AND TO_CHAR(ROLLUP_TIMESTAMP,'DD') = '01'
           AND METRIC_COLUMN = 'USED_GB'
      GROUP BY TARGET_NAME, TO_CHAR(ROLLUP_TIMESTAMP,'YYYY-MM-DD')) a 
     , (SELECT TARGET_NAME 
             , TO_CHAR(ROLLUP_TIMESTAMP,'YYYY-MM-DD') DTTM
             , TO_CHAR(MAX(AVERAGE),'999999.99') ALLOC_GB
          FROM MGMT$METRIC_DAILY 
         WHERE METRIC_NAME = 'DATABASE_SIZE'
           AND TO_CHAR(ROLLUP_TIMESTAMP,'DD') = '01'
           AND METRIC_COLUMN = 'ALLOCATED_GB'
      GROUP BY TARGET_NAME, TO_CHAR(ROLLUP_TIMESTAMP,'YYYY-MM-DD')) b
 WHERE A.TARGET_NAME = B.TARGET_NAME
   AND A.DTTM = B.DTTM
ORDER BY HOST_NAME, DATABASE, DTTM;