Re: Indexes size

User-segments is about the space reserved for the object, (hence unavailable to any other object). dbms_space is about the space actually used within that reserved space

You can also get a third set of figures from user_indexes/user_tables which is the results of the calculation of space used as at the last call to the ANALYZE command.

--

Jonathan Lewis
Yet another Oracle-related web site: www.jlcomp.demon.co.uk

Enzo De Caro wrote in message <7ldk5k$4ab$1_at_aquila.tiscalinet.it>...
>Hello, it's me again... there is a typo.. the right view is user_segments,
>not user_objects...
>Enzo.
>
>Enzo De Caro <edecaro_at_tiscalinet.it> wrote in message
>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!
Received on Wed Jun 30 1999 - 13:15:14 CDT