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: PCTFREE & PCTUSED

Re: PCTFREE & PCTUSED

From: Douglas Cowles <dcowles_at_us.ibm.com>
Date: 2000/03/09
Message-ID: <38C7EB17.AB7CE792@us.ibm.com>#1/1

I think Q2 is low pctfree, not low pctused, since if it has no room to perform an update, the row will migrate..also you forgot inittrans and maxtrans. Question 7 - higher inittrans...

Michael Riedl wrote:

> Q1: PCTFREE
> Q2:low PCTUSED
> Q3:noramly PCTFREE 20% and PCTUSED 80%
> Q4:answer Q3
> Q5:i don't know what you mean?
> Q6: answer Q3
>
> J schrieb:
>
> > I have some questions about the usage of PCTFREE & PCTUSED. Hope anyone can
> > give me the answer along with the explanation.
> > T.I.A
> >
> > Vurley
> >
> > =============================================
> > Q: Which parameter reserves the more space for future updates
> >
> > 1. high PCTINCREASE
> > 2. high PCTFREE
> > 3. high INITIAL
> > 4. high PCTUSED
> >
> > Q: Row migration is a result of
> >
> > 1. high PCTFREE
> > 2. low PCTFREE
> > 3. high PCTUSED
> > 4. low PCTUSED
> >
> > Q: If the space usage parameters are set to the default clause, which change
> > could cause higher processing costs because blocks will be considered
> > free more often.
> >
> > A. raising PCTUSED
> > B. raising PCTFREE
> > C. lowering PCTUSED
> > D. lowering PCTFREE
> >
> > Q : Which setting for the storage parameter should you use if tables are
> > updated very infrequently
> >
> > 1. low PCTUSED
> > 2. high PCTUSED
> > 3. low PCTFREE
> > 4. high PCTFREE
> >
> > Q : If your table grows significantly, which storage parameter should you
> > increase
> >
> > 1. MAXEXTENTS
> > 2. PCTINCREASE
> > 3. PCTFREE
> > 4. PCTUSED
> >
> > Q: Which parameter value should you use if tables have frequent inserts and
> > deletes
> >
> > 1. low PCTUSED
> > 2. high PCTUSED
> > 3. low PCTFREE
> > 4. high PCTFREE
> >
> > Q: You are creating the LINE_ITEM table that will experience extensive
> > insert activity.
> > Which space utilization parameter setting is most appropriate for the table?
> >
> > A. low PCTUSED
> > B. low PCTFREE
> > C. high PCTUSED
> > D. high PCTFREE
Received on Thu Mar 09 2000 - 00:00:00 CST

Original text of this message

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