Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Increase FREEIST w/o drop objects

Re: Increase FREEIST w/o drop objects

From: Tanel Põder <tanel.poder.003_at_mail.ee>
Date: Sun, 3 Oct 2004 00:02:46 +0300
Message-ID: <018a01c4a8c3$2b36fe90$39bd9fd9@porgand>


> Why Oracle said that to increase the FREELISTS you MUST RECREATE THE
OBJECTS? Please reference, where is this stated?

This is from 9.2 RAC deployment doc:

"You cannot change the value of FREELIST GROUPS with the ALTER TABLE, ALTER CLUSTER, or ALTER INDEX statements unless you export, drop, rebuild, and reload the table. However, you can dynamically change the setting for the FREELISTS parameter with the ALTER TABLE, ALTER INDEX, or ALTER CLUSTER statements."

So, you can dynamically change freelists for a segment (they're just small pointers inside segment header). But if you want to change number of freelist groups using alter command, the whole contents of segment have to be physically copied to another location within an Oracle datafile, because Oracle wants to keep freelist group blocks right after segment header...

Tanel.

>
> How about just
>
> ALTER object_type object_name STORAGE (FREELISTS higher_value);
>
> or
>
> ALTER object_type object_name
> MOVE STORAGE (FREELIST higher_value FREELIST GROUPS
higher_ value);
>
> Thanks
> Sinardy
>
> --
> http://www.freelists.org/webpage/oracle-l

--
http://www.freelists.org/webpage/oracle-l
Received on Sat Oct 02 2004 - 15:58:29 CDT

Original text of this message

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