Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: PCTFREE & PCTUSED
In article <38C7983A.7682_at_btinternet.com>,
High.Flight_at_btinternet.com wrote:
..
>> Q: Row migration is a result of
>>
>> 1. high PCTFREE
>> 2. low PCTFREE ** CORRECT **
>> 3. high PCTUSED
>> 4. low PCTUSED
Not growth in row length?
..
>> Q : If your table grows significantly, which storage parameter should you
>> increase
>>
>> 1. MAXEXTENTS
>> 2. PCTINCREASE ** CORRECT **
>> 3. PCTFREE
>> 4. PCTUSED
But as your tablespace gets more full and
fragmented you'll be trying to take larger and
larger extents? I never use PCTINCREASE, I want
all my next extents to be the same size (1m, or
10m for big objects).
..
Paul de Anguera | "You can't write a chord ugly enough to say Reply to: | what you want to say sometimes, so you have to deanguer@ | rely on a giraffe filled with whipped cream." quidnunc.net | - Frank ZappaReceived on Mon Mar 13 2000 - 00:00:00 CST
![]() |
![]() |