About Me Contact Me Oracle12cSIG(IOUG)
Home  :: Database Tablespace FreeSpace

Database Tablespace FreeSpace


Query for Database Tablespace Free Space

set pagesize 100;
set linesize 200;
col file_name format a50;
select a.tablespace_name,a.bytes MB_used,b.bytes MB_free,round(((a.bytes-b.bytes)/a.bytes)*100,0) percent_used
from (select tablespace_name,ceil(sum(bytes/1024/1024)) bytes from dba_data_files group by TABLESPACE_NAME) a, (select
tablespace_name,ceil(sum(bytes/1024/1024)) bytes from dba_free_space group by tablespace_name) b
where a.tablespace_name=b.tablespace_name order by round(((a.bytes-b.bytes)/a.bytes)*100,0) desc;

Posted on : 2/21/2014 by Anuj
No comment found.

Add Your Comments
Name :
Email :
Comments :


  Recent Posts

Oracle Database 19c is available via LiveSQL
Posted on :   1/21/2019

How Do I Find the Exadata Documentation, Such as Owner and User Guide
Posted on :   5/31/2018

Exachk 18.2.0_20180518 is available now…
Posted on :   5/20/2018

  Recent Comments

Home  |  About Me  |  Contact  |  Oracle12cSIG(IOUG)

All Rights Reserved © 2013 Oracle-12c