Re: how determine unused space for indexes

And when compared to my suggestion, will fly like a Concorde while I pedal on my pushy.

Not one of my best.

Richard
"Steve Ashmore" <sashmore_at_neonramp.com> wrote in message news:uib85kaao6lhc4_at_corp.supernews.com...
> One method is to use the oracle supplied dbms_space
> package. Simply write a wrapper around it and
> run it against all your indexes and output the results to a file
> or a table.
>
> Stephen C. Ashmore
> Brainbench MVP for Oracle Administration
> http://www.brainbench.com
>
> Author of: 'So You Want to be an Oracle DBA?'
>
>
>
> "Mikael Kruse" <mikael.kruse_at_ehs.ericsson.se> wrote in message
> news:ag43v0$ech$1_at_newstoo.ericsson.se...
> > Hi,
> >
> > I'm suspecting that a database that I use for test could be created with
a
> > lot smaller extents than current settings. To investigate this, I want
to
> > find out how much of the space allocated for my indexes (many indexes)
> > that's really used. I don't know if there's a High Water Mark for index
> > segments as there is for table segments, but if there is, I want to know
> how
> > much of the space allocated that's below/above High Water Mark. Can
anyone
> > help me with this? I need a method that can be applied on many indexes,
> > since I can't go through them one by one, there are far too many...
> >
> > Oracle version 8.0.5
> >
> > Thankful for assistance
> > /Mikael
> >
> >
>
>
Received on Fri Jul 05 2002 - 09:17:57 CDT