Re: Indexes size

Answer inline...

Sybrand Bakker wrote:

> Hi Enzo,
>
> I am afraid your are looking in the wrong place.
> The size of an index is to be found in dba_segments or user_segments
> select bytes
> from user_segments
> where segment_name = '<index name>';

Yes, i had figured this much.

>
>
> The dbms_space call you mention is providing you with the free space in any
> segment.

Wrong. dbms_space.unused_space ALSO return total bytes (and blocks) and much much more.....Do a describe and look at all the "OUT" parms...

>
>
> So the two figures should probably never be the same.
>
> Hth,
> Sybrand Bakker, Oracle DBA
>
> Enzo De Caro <edecaro_at_tiscalinet.it> wrote in message
> news:7lddgg$pbc$1_at_aquila.tiscalinet.it...
> > Hello everybody,
> >
> > my name is Enzo, i'm an italian DBA and i've an unanswered question about
> > the size of a created index.
> >
> > The size of an index can be seen in column bytes of view user_objects or
> can
> > be extracted from the results of dbms_space.unused_space package. I
> expected
> > the same number from differents source.
> > Surprise. The numbers are differents!
> > Can someone tell me why?
> >
> > Thanks.
> > Enzo.
> >
> >
Received on Wed Jun 30 1999 - 12:58:56 CDT