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: Any dangers when changing pctfree etc on live system ?

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

From: Holman, Rodney <rodney.holman_at_lodgenet.com>
Date: Wed, 1 Nov 2000 14:27:52 -0600
Message-Id: <10667.120857@fatcity.com>


Shouldn't be a problem. It won't change any blocks that are currently used. It will only take effect on blocks allocated after the change.

Rodd Holman
Enterprise Data Systems Engineer
LodgeNet Entertainment Corporation
rodney.holman_at_lodgenet.com

-----Original Message-----
From: Steve.Parker_at_lis.co.uk [mailto:Steve.Parker_at_lis.co.uk] Sent: Wednesday, November 01, 2000 11:46 AM To: Multiple recipients of list ORACLE-L Subject: Any dangers when changing pctfree etc on live system ?

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). Received on Wed Nov 01 2000 - 14:27:52 CST

Original text of this message

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