Monthly Archives: August 2012

Query for Tablespace usage with Autoextend

Sine i need to check the maximum size of tablespace with autoextend enabled i write the following query: set linesize 100 set pagesize 100 select                 a.tablespace_name,                 round(SUM(a.bytes)/(1024*1024*1024)) CURRENT_GB,                 round(SUM(decode(b.maxextend, null, A.BYTES/(1024*1024*1024), b.maxextend*8192/(1024*1024*1024)))) MAX_GB,                 (SUM(a.bytes)/(1024*1024*1024) – round(c.Free/1024/1024/1024)) … Continue reading

Posted in Oracle in general | 5 Comments