TechWare

FIND TABLESPACE SIZE USAGE AND FREE SPACE : ------------------------------------------- select    tablespace_name,    used_percent from    dba_tablespace_usage_metrics where    used_percent > 90;   SELECT  a.tablespace_name,     ROUND (((C.BYTES - NVL (B.BYTES, 0)) / C.BYTES) * 100,2) PERCENTAGE_USED,     C.BYTES / 1024 / 1024/ 1024 SPACE_ALLOCATED,     ROUND (C.BYTES / 1024 / 1024/ 1024 - NVL (B.BYTES, 0) / 1024 / 1024/ 1024,2) SPACE_USED,     ROUND (NVL (b.BYTES, 0) / 1024 / 1024/ 1024, 2) space_free,       c.DATAFILES   FROM dba_tablespaces a,        (    SELECT   tablespace_name,                     SUM (BYTES) BYTES            FROM...