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 -> Indexes size

Indexes size

From: Enzo De Caro <edecaro_at_tiscalinet.it>
Date: Wed, 30 Jun 1999 17:35:58 +0200
Message-ID: <7lddgg$pbc$1@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 - 10:35:58 CDT

Original text of this message

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