Re: Any dangers when changing pctfree etc on live system ?

I take back my last e-mail.

Even if the pctfree changes, a used block will not have its pctfree credits examined unless and until there's DML on the block. There, it will be eligible for the freelist unless and until....
----- Original Message -----
From: Ron Rogers <RROGERS_at_galottery.org> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Sent: Wednesday, November 01, 2000 3:27 PM Subject: Re: Any dangers when changing pctfree etc on live system ?

> Steve,
> When you change the pctfree on a table it only effects the new blocks of data added to the table. The old blocks still maintain
the old setting. To eliminate the old block setting you should save the data and recreate the table with the new settings and reload the data.
> ROR ª¿ª
>
> >>> Steve.Parker_at_lis.co.uk 11/01/00 12:46PM >>>
> List,
>
> A fellow DBA has asked if it is completely safe to change the pctfree
> values etc on a live
> system.
>
> I thought there shouldn't be any isues as no data is actually being changed
> only
> the default storage parameters that will be used when new blocks are
> created.
>
> Any experience, gotchas etc appreciated
>
> Steve Parker
> Technical Consultant
> LIS
>
> ------------------------------
> Logistics & Internet Systems Ltd.
> United Kingdom
> E Mail: steve.parker_at_lis.co.uk
> ------------------------------
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
> INET: Steve.Parker_at_lis.co.uk
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> 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: Ron Rogers
> INET: RROGERS_at_galottery.org
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> 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 Wed Nov 01 2000 - 16:30:16 CST