Actual index sizes
From: Chuck Hamilton <chuckh_at_ix.netcom.com>
Date: 1995/12/14
Message-ID: <4apijg$1r1_at_cloner2.ix.netcom.com>#1/1
Date: 1995/12/14
Message-ID: <4apijg$1r1_at_cloner2.ix.netcom.com>#1/1
Is there a way to find out exactly how much space an index is actually using? What I want to do is find out if any of my index initial segments are radically oversized, and if they are, I want to drop them and recreate them at a more reasonable size.
I think DBA_SEGMENTS will only give me how big the initial extent is. I want to know much of it is actually being used.
-- Chuck Hamilton chuckh_at_ix.netcom.com Never share a foxhole with anyone braver than yourself!Received on Thu Dec 14 1995 - 00:00:00 CET