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

Home -> Community -> Usenet -> c.d.o.server -> Re: Fragmenation Question

Re: Fragmenation Question

From: dave mausner <dmausner_at_ameritech.x.net>
Date: Tue, 11 Jan 2000 05:57:08 GMT
Message-ID: <8EB7F3351dlm@206.141.192.241>


markp7832_at_my-deja.com wrote in <85d5li$ecc$1_at_nnrp1.deja.com>:

>In article <bJ55OI0HN0bPafA00Tnicb3zPj5W_at_4ax.com>,
> jgonzalezsNO_at_SPAMoviedo.syseca.es wrote:
>> On Wed, 05 Jan 2000 05:55:00 GMT, dmausner_at_ameritech.x.net (dave
>> mausner) wrote:
>> So, What's the *best* settings for pctfree and pctused params for a
>> table of historical data, which you insert data along time but never
>> update or delete?

the correct answer is pctfree=0 (pctused doesn't matter) for a table of historial data which never changes. this means you do not intend to add columns, either.
--
dave mausner Received on Mon Jan 10 2000 - 23:57:08 CST

Original text of this message

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