Re: Used size of a datafile.
- From: Jared Still <jkstill@xxxxxxxxx>
- To: jhn.aida@xxxxxx
- Date: Sat, 8 Jan 2005 11:09:55 -0800
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@xxxxxx> 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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
