Hi Suresh,

This script will tell you something about the filling of your database

Tycho

select a.tablespace_name,
a.ts_size_in_MB,
b.ts_free_space,
round(((a.ts_size_in_MB-b.ts_free_space)/a.ts_size_in_MB)* 100,2) percentage
from (select tablespace_name,
round(sum(bytes)/(1024*1024)) ts_size_in_MB
from dba_data_files
group by tablespace_name) a,
(select tablespace_name,
round(sum(bytes)/(1024*1024)) ts_free_space
from dba_free_space
group by tablespace_name) b
where a.tablespace_name = b.tablespace_name (+)
order by b.ts_free_space