RE: Is the effect of modifying PCTFREE/PCTUSED immediate ?

From: <John.Hallas_at_vodafone.co.uk>
Date: Tue, 24 Sep 2002 03:28:43 -0800
Message-ID: <F001.004D79A3.20020924032843@fatcity.com>

No, it is not retrospective.
You are setting parameters to be used when the next extent is created. A better example is when setting next extent size to be different than the existing extent size (dictionary managed tablespaces only). It does not alter all the existing extents it only works on the next one that is created.

HTH John

-----Original Message-----
Sent: 24 September 2002 10:58
To: Multiple recipients of list ORACLE-L

Is the effect of modifying PCTFREE/PCTUSED immediate ?

If I do an "ALTER TABLE <tablename> PCTFREE 99 PCTUSED1", does this take effect immediately, even for existing blocks. [If so, existing blocks would not get new rows inserted]. Or is it effective only in new Extents ? In that case, existing blocks in existing Extents still use the old PCTFREE/PCTUSED parameters and keep re-entering the FreeList.  

Hemant K Chitale
http://hkchital.tripod.com
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: hkchital
  INET: hkchital_at_singnet.com.sg

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author:
  INET: John.Hallas_at_vodafone.co.uk

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Tue Sep 24 2002 - 06:28:43 CDT