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: Michael Riedl <michael.riedl_at_ivm-solve-it.com>
Date: 2000/03/09
Message-ID: <38C79FF5.ECBD5ABA@ivm-solve-it.com>#1/1

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