Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Oracle PCTUSED/PCTFREE settings
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 UsenetReceived on Thu Sep 04 1997 - 00:00:00 CDT
![]() |
![]() |