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: I am confused re PCTFREE and PCTUSED...

Re: I am confused re PCTFREE and PCTUSED...

From: Marc Mazerolle <informaze_at_sympatico.ca>
Date: Wed, 26 May 1999 15:10:13 GMT
Message-ID: <374C0FF5.F5131216@sympatico.ca>


Nasir,

Here is my 2 cents :

With PCTFREE=20 and PCTUSED=40 (defaults)

Regards,

Marc Mazerolle
InforMaze Technologies

NNOOR wrote:

> Hi,
>
> Following is straight from Oracle documentation
> re: PCTFREE and PCTUSED: "After the free space in a data
> block reaches PCTFREE, no new rows are inserted in that
> block until the percentage of space used falls below PCTUSED."
>
> I am a little confused. Say that PCTFREE is 20 (default) and
> PCUSED is 40 (default). Does that mean, that any given time
> (assuming updates do not occur at a very high rate, and if
> they do, they do not change the data size significantly), the
> maximum space used in a block is only 40%?---20% is left free
> for updates, and data base will stop inserting rows into the
> block when it reaches 40% used. Am I drawing correct conclusions
> from the statement quoted above?
>
> Thanks and Regards,
> Nasir Noor (nnoor_at_cris.com)
Received on Wed May 26 1999 - 10:10:13 CDT

Original text of this message

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