Re: Used size of a datafile.

You may consider using DBA_FREE_SPACE rather than DBA_EXTENTS.

If there are a lot of objects in your database, it may be (possibly much) less expensive to query DBA_FREE_SPACE.

On Sat, 08 Jan 2005 11:15:32 +0100, Jesper Haure Norrevang <jhn.aida_at_cbs.dk> wrote:
> Vinod,
>
> select
> f.tablespace_name,
> f.file_name,
> sum(e.bytes) / 1024 / 1024 MB
> from dba_extents e, dba_data_files f
> where e.file_id = f.file_id
> group by f.tablespace_name, f.file_name
> order by f.tablespace_name, f.file_name;
>

-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
--
http://www.freelists.org/webpage/oracle-l