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

Home -> Community -> Usenet -> c.d.o.misc -> Oracle PCTUSED/PCTFREE settings

Oracle PCTUSED/PCTFREE settings

From: Michael E. Moores <moores_at_digitech.net>
Date: 1997/09/04
Message-ID: <873386452.14220@dejanews.com>#1/1

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
Received on Thu Sep 04 1997 - 00:00:00 CDT

Original text of this message

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