Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle PCTUSED/PCTFREE settings
In article <873386452.14220_at_dejanews.com>,
moores_at_digitech.net wrote:
>
> I'm a little confused in determining the optimal value for PCTUSED.
> I understand the principle, but well-known documentation
> (Oracle DBA manual, Oracle Design by O'Reilly) contradicts each other.
> I am inclined to set PCTUSED to zero, instead of leaving it at the
> default
> of 40.
> WHy does it matter how many deletes/updates i do? Is it okay
> to bring a block off of the free list when the block is empty?
>
> --Michael
>
> -------------------==== Posted via Deja News ====-----------------------
> http://www.dejanews.com/ Search, Read, Post to Usenet
I meant to say "Is it okay
> to put a block ON the free list when the block is empty?
--MIchael
-------------------==== Posted via Deja News ====----------------------- http://www.dejanews.com/ Search, Read, Post to UsenetReceived on Thu Sep 04 1997 - 00:00:00 CDT
![]() |
![]() |