Re: Extent Analysis

From: <manoj67_at_hotmail.com>
Date: 1998/03/30
Message-ID: <6fpmgc$ltr$1@nnrp1.dejanews.com>#1/1

Try following query :

select a.tablespace_name,sum(a.blocks/b.blocks*100) from dba_free_space a, dba_data_files b
where a.file_id = b.file_id
group by a.tablespace_name

This will give the %free of the tablespaces. ( The output includes all the free extents in the tablespace ).

Hope this helps,

Manoj Jain
Oracle DBA.

In article <1998033010250901.FAA01588_at_ladder01.news.aol.com>, htrieu_at_aol.com (HTrieu) wrote:
>
>
> I would appreciate any assistance in a simple sql script to analyze the
> freespace in an extent. I have a 4GB table in a 78GB database and I am
> trying to size growth of this tablespace. Please excuse my "inexperience"
> inheritance aspect of the job.
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Mon Mar 30 1998 - 00:00:00 CST