-
Archives
- April 2019
- March 2019
- September 2018
- August 2016
- July 2016
- May 2015
- April 2015
- December 2014
- November 2014
- August 2014
- February 2014
- January 2014
- November 2013
- July 2013
- June 2013
- March 2013
- December 2012
- September 2012
- August 2012
- July 2012
- June 2012
- May 2012
- March 2012
- October 2011
- August 2011
- June 2011
- May 2011
- April 2011
- March 2011
- December 2010
- November 2010
- October 2010
- August 2010
- July 2010
- May 2010
- April 2010
- March 2010
- February 2010
- January 2010
- December 2009
- November 2009
- October 2009
- September 2009
-
Meta
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