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 -> Re: Oracle PCTUSED/PCTFREE settings

Re: Oracle PCTUSED/PCTFREE settings

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

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 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