Skip to content

Instantly share code, notes, and snippets.

@brianstorti
Created December 20, 2011 17:52
Show Gist options
  • Save brianstorti/1502497 to your computer and use it in GitHub Desktop.
Save brianstorti/1502497 to your computer and use it in GitHub Desktop.
Oracle tablespace size
select a.TABLESPACE_NAME,
a.BYTES bytes_used,
b.BYTES bytes_free,
b.largest,
round(((a.BYTES-b.BYTES)/a.BYTES)*100,2) percent_used
from
(
select TABLESPACE_NAME,
sum(BYTES) BYTES
from dba_data_files
group by TABLESPACE_NAME
)
a,
(
select TABLESPACE_NAME,
sum(BYTES) BYTES ,
max(BYTES) largest
from dba_free_space
group by TABLESPACE_NAME
)
b
where a.TABLESPACE_NAME=b.TABLESPACE_NAME
order by ((a.BYTES-b.BYTES)/a.BYTES) desc;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment