Замена обрезки базы Супермаг+ : Супермаг Плюс (Супермаг 2000)

select  a.TABLESPACE_NAME,
  a.GB "Size in GB",
  nvl(b.GB, 0) "Free space in GB",
  nvl(round(((a.BYTES-b.BYTES)/a.BYTES)*100,2), 100) percent_used
from   
  (
    select   TABLESPACE_NAME,
      sum(BYTES) BYTES, 
      round(sum(BYTES)/1024/1024, 2) MB,
      round(sum(BYTES)/1024/1024/1024, 2) GB 
    from   dba_data_files 
    group   by TABLESPACE_NAME
  )
  a,
  (
    select   TABLESPACE_NAME,
      sum(BYTES) BYTES, 
      round(sum(BYTES)/1024/1024, 2) MB,
      round(sum(BYTES)/1024/1024/1024, 2) GB 
    from   dba_free_space 
    group   by TABLESPACE_NAME
  )
  b
where   a.TABLESPACE_NAME=b.TABLESPACE_NAME (+)
order   by 1;