Re: Determining size of existing index

Chuck Hamilton wrote:
>
> What's the best way to determine the size of an existing index?
> --
> Chuck Hamilton
> chuckh_at_ix.netcom.com
>
> Incoming fire has the right of way!

The following statement will give you total size taken up by the index (remember that some of that may not be used yet due to extent sizes and PCT_FREE parameters):

SELECT sum(bytes)
FROM user_extents
WHERE segment_name = 'PUT YOUR INDEX NAME IN HERE';

-- 
Andy Yun			(Work) 805-447-1791
Senior Consultant		(Home) 818-227-4949
InfoSys Corporation		(Fax)  818-227-4948
Woodland Hills, CA		(Email) ayun_at_amgen.com
Oracle RDBMS Specialists