| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Any dangers when changing pctfree etc on live system ?
Hi Ron,
A minor correction: The new PCTFREE value will also be effective for any blocks currently on a freelist, or subsequently placed on a freelist (by virtue of falling below PCTUSED).
@ Regards, @ Steve Adams @ http://www.ixora.com.au/ @ http://www.christianity.net.au/
-----Original Message-----
From: Ron Rogers [mailto:RROGERS_at_galottery.org]
Sent: Thursday, 2 November 2000 7:27
To: Multiple recipients of list ORACLE-L
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
-- 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 mayReceived on Wed Nov 01 2000 - 17:37:56 CST
 |
 |