Re: Indexes size

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>';

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

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:09:24 CDT