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 -> Re: Index reaching max extents

Re: Index reaching max extents

From: NetComrade <andreyNSPAM_at_bookexchange.net>
Date: Tue, 14 Sep 1999 15:59:41 GMT
Message-ID: <37de6ff9.130699013@news.earthlink.net>


On Mon, 13 Sep 1999 18:31:32 -0500, Tapan Trivedi <tapan.trivedi_at_abbnm.com> wrote:
>
>Hey guys,
> I have an index which is reaching near its max extents and I am not in
>a position to increase the max-extents due to the restrictions posed
>upon the system. What can I do ? Will rebuilding the index solve the
>problem ??
>
>Any hints ,experiences , suggestions are welcome.
>

ALTER INDEX <index_name> REBUILD
STORAGE (INITIAL <set to value equal to the following query> NEXT <depends on growth, I usually set it to 1/2 of INITIAL>)

select extents, bytes, owner||'.'||segment_name, segment_type from dba_segments
where segment_name=<index_name>

Example
ALTER INDEX MANAGER_PK REBUILD
STORAGE (INITIAL 100M NEXT 50M)


Andrey Dmitriev	 eFax: (978) 383-5892  Daytime: (917) 373-5417
AOL: NetComrade	 ICQ: 11340726 remove NSPAM to email

Received on Tue Sep 14 1999 - 10:59:41 CDT

Original text of this message

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