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: Q:Good preformance

Re: Q:Good preformance

From: JC <jcygan_at_netxpress.com>
Date: 1997/09/20
Message-ID: <3425d1ab.2907150@206.67.207.6>#1/1

On 19 Sep 1997 09:58:58 GMT, "Sanlam" <joe_at_soap.com> wrote:
>you indicate how it was created and if there is contention. For inserts and
>updates you have to look at the parameters on the tables PCTUSED, PCTFREE
>as well as storage parameters for fragmentation.

I am still confused on PCTUSED, PCTFREE. Could someone give me a good plain english explanation of how these influence performance. I understand what row chaining is, and how bad it can potentially be. Is that the sole concern with these settings?

Joe Received on Sat Sep 20 1997 - 00:00:00 CDT

Original text of this message

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