Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> R: Indexes size

R: Indexes size

From: Enzo De Caro <edecaro_at_tiscalinet.it>
Date: Wed, 30 Jun 1999 19:28:40 +0200
Message-ID: <7ldk5k$4ab$1@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!
> Can someone tell me why?
>
> Thanks.
> Enzo.
>
>
Received on Wed Jun 30 1999 - 12:28:40 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US