Re: Extent Analysis

manoj67_at_hotmail.com wrote:
>
> 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

Have a look in ORACLE_HOME/rdbms/admin in dbmsutil.sql

The dbms_space package may be what you are after...

Cheer

-- 
==========================================
Connor McDonald
BHP Information Technology
Perth, Western Australia
"These views mine not BHP..etc etc"

"The only difference between me and a madman is that I am not mad."