oracleScripts

Tablespace Usage

Tablespace Used , Free & Total Sizes of each tablespaces set linesize 160 set pagesize 300 select distinct a.tablespace_name, SUM(a.bytes)/1024/1024 "Used Size MB", SUM(decode(b.maxextend, null, A.BYTES/1024/1024, b.maxextend*8192/1024/1024)) "Max Size Mb", (SUM(a.bytes)/1024/1024 - round(c."Free"/1024/1024)) "Total Used MB", (SUM(decode(b.maxextend, null, A.BYTES/1024/1024, b.maxextend*8192/1024/1024)) - (SUM(a.bytes)/1024/1024 - round(c."Free"/1024/1024))) "Total Free MB", round(100*(SUM(a.bytes)/1024/1024 - round(c."Free"/1024/1024))/(SUM(decode(b.maxextend, null,