Health Check version 12 vs 13

Toad for Oracle & DevOps Toolkit
7

Using spool SQL, I grabbed the SQL for 12.1 and 13.3 (which is the same as 13.2) and ran them against database oracle versions 12c, 12cR2, 18c, and 19c. You can see that the SQL is quite different, but for me, the result was the same each time. Try repeating this test on your database.

--Toad 12.1

select df.tablespace_name,  round(df.total_bytes / 1048576) total_mb,
       round(nvl(fs.free_bytes,0) / 1048576) free_mb,
       round(100 * nvl(fs.free_bytes,0) / df.total_bytes, 1) percent_empty
from
  (Select tablespace_name, sum(bytes) total_bytes
   from dba_data_files
   where tablespace_name not in ('SYSTEM')
   group by tablespace_name) df,
  (Select tablespace_name, sum(bytes) free_bytes
   from dba_free_space
   where tablespace_name not in ('SYSTEM')
   group by tablespace_name) fs
where df.tablespace_name  = fs.tablespace_name (+)
and nvl(fs.free_bytes,0) / df.total_bytes <= (10 / 100);

-- Toad 13.3 (ignoring auto extend)

Select tablespace_name,
       current_file_size_in_mb total_mb,
       free_mb_in_current free_mb,
       current_file_size_pct_free percent_empty
from (select files.tablespace_name,
             round(files.current_bytes / 1048576) current_file_size_in_mb,
             round((files.current_bytes - free.free_bytes) / 1048576) used_mb,
             round(free.free_bytes/ 1048576) free_mb_in_current,
             round(100 * nvl(free.free_bytes, 0) / files.current_bytes, 1) current_file_size_pct_free,
             round(files.max_bytes / 1048576) max_file_size_mb,
             round((files.max_bytes - (files.current_bytes - nvl(free.free_bytes, 0))) / 1048576) free_mb_in_max,
             round(100 * (files.max_bytes - (files.current_bytes - nvl(free.free_bytes, 0))) / files.max_bytes, 1) max_file_size_pct_free
      from (select tablespace_name,
                   sum(current_bytes) current_bytes,
                   sum(max_bytes) max_bytes
            from   (Select df.tablespace_name,
                           df.bytes current_bytes,
                           decode(df.autoextensible, 'YES', df.maxbytes, 'NO', df.bytes) max_bytes
                    from   dba_data_files df
                    where tablespace_name not in ('SYSTEM'))
            group by tablespace_name) files,
           (Select tablespace_name,
                   sum(bytes) free_bytes
            from   dba_free_space
            where tablespace_name not in ('SYSTEM')
            group by tablespace_name) free
      where  free.tablespace_name (+) = files.tablespace_name)
where   current_file_size_pct_free < 10;