Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: PCTFREE & PCTUSED
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