Oracle ovm-repodb01:/nfs01/scripts/beheer_scripts/bin - brd02

I run those both scripts on the BRD02 and PGISGEO databases and see below Where free.tablespace_name (+) = files.tablespace_name) Round(100 * (files.max_bytes - (files.current_bytes - nvl(ee_bytes, 0))) / files.max_bytes, 1) max_file_size_pct_freeĭecode(df.autoextensible, 'YES', df.maxbytes, 'NO', df.bytes) max_bytes Round(files.max_bytes / 1048576) max_file_size_mb, Round(100 * nvl(ee_bytes, 0) / files.current_bytes, 1) current_file_size_pct_free, Round((files.current_bytes - ee_bytes) / 1048576) used_mb, Round(files.current_bytes / 1048576) current_file_size_in_mb, Toad 13.3 (ignoring auto extend) Select tablespace_name, Where df.tablespace_name = fs.tablespace_name (+)Īnd nvl(fs.free_bytes,0) / df.total_bytes <= (10 / 100) (Select tablespace_name, sum(bytes) free_bytes (Select tablespace_name, sum(bytes) total_bytes Round(100 * nvl(fs.free_bytes,0) / df.total_bytes, 1) percent_empty

Toad 12.1 select df.tablespace_name, round(df.total_bytes / 1048576) total_mb, Try repeating this test on your database. You can see that the SQL is quite different, but for me, the result was the same each time. 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.

Toad latest version for oracle 12c