Tablespace_Details

Select A.Tablespace_Name, B.Total/1024/1024 "Total_MB",
       (B.Total-a.Total_Free)/1024/1024 "MB_Used",
       A.Total_Free/1024/1024 "MB_Free",
       (A.Total_Free/B.Total) * 100 "Pct_Free",
       ((B.Total-A.Total_Free)/B.Total) * 100 "Pct_Used"
  From (Select Tablespace_Name, Sum(Bytes) Total_Free
          From Sys.Dba_Free_Space
         Group By Tablespace_Name     ) A
     , (Select Tablespace_Name, Sum(Bytes) Total
          From Sys.Dba_Data_Files
         Group By Tablespace_Name     ) B
Where A.Tablespace_Name LIKE upper('%&Tablespace%')
  And A.Tablespace_Name = B.Tablespace_Name
 --AND ((B.Total-A.Total_Free)/B.Total) * 100 > 96
ORDER BY 1;