Re: Indexes size

What version of Oracle r u using ?

Under 7.3, there is no "bytes" column in user_objects view.....

Regards,

Marc Mazerolle

Enzo De Caro wrote:

> 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 - 11:49:07 CDT