On 02/16/2004 11:36:03 PM, "Kommareddy, Srinivas (MED, Wissen
Infotech)" wrote:
> want to add space to index tablespace also... (most of the indexes
> columns are NUMBER, should I take 32 bytes * n rows to calculate the
> size )
>

How did you arrive to 32 bytes? rowid is 10 bytes, so you have
10+vsize(key1)+vsize(key2)+vsize(key3)+...+vsize(keyn)
for the leaf block entry. For non-leaf blocks, you have to add
approximately 20% overhead (I use that number, it's a good
approximation). That is, of course, a B-tree index. I don't know
how to calculate bitmap index size. My guestimate, pulled out of
my left thumb would be 20% of the size of the coresponding B-tree
index. After all, disks are cheap, especially if somebody else pays
for them.

--
Mladen Gogala
Oracle DBA
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@(protected)
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------