To Check All The Tablespaces Size
select
fs.tablespace_name "Tablespace",
df.totalspace "TOT_SIZE",
fs.freespace "TOT_FREE",
(round(100 * (fs.freespace / df.totalspace))) pct_Free
from
(select tablespace_name,
round(sum(bytes) / 1048576) TotalSpace
from
dba_data_files
group by
tablespace_name
) df,
(select
tablespace_name,
round(sum(bytes) / 1048576) FreeSpace
from
dba_free_space
group by
tablespace_name ) fs
where (df.tablespace_name = fs.tablespace_name ) ORDER BY pct_free DESC ;
No comments:
Post a Comment