Re: ACTUAL INDEX SIZE

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Thu, 7 Oct 1999 11:22:30 +0100
Message-ID: <939291787.19621.1.nnrp-04.9e984b29@news.demon.co.uk>

Slow way - analyze index and look at stats

(e.g. analyze index validate structure, then look in index_stats)

Quick way - use the dbms_space package

There is a sample of dbms_space usage
on my web-site.

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

Wesley wrote in message <7thrj9$dsh$1_at_nnrp1.deja.com>...
>Hi,
>
>Could anyone tell me how to calculate the actual size occupied by
>an index?
>
>TIA.
>
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.
Received on Thu Oct 07 1999 - 05:22:30 CDT