updated oracle_table_space.sql

HariSekhon · Oct 17, 2024 · 59b9141 · 59b9141
1 parent e663415
commit 59b9141
Showing 1 changed file with 1 addition and 1 deletion.
diff --git a/oracle_table_space.sql b/oracle_table_space.sql
@@ -38,7 +38,7 @@ WHERE
     num_rows > 0
         AND
     ((blocks * 8 / 1024 / 1024) - (num_rows * avg_row_len / 1024 / 1024 / 1024)) /
-    (blocks * 8 / 1024 / 1024) > 0.2
+    (blocks * 8 / 1024 / 1024) > 0.2  -- TUNE: currently only showing tables with over 20% free space
         AND
     owner NOT IN
       ('SYS', 'SYSTEM', 'SYSAUX', 'RDSADMIN')