posted 22 years ago
there's a question on this subject on the Oracle OCP study guide on fundamentals I:
You are configuring block space utilization on an Oracle table. which of following choice identifies block space utilization settings that are never appropriate under any circumstances?
a) pctfree 20, pctused 70
b) pctfree 15, pctused 80
c) pctfree 10, pctused 40
d) pctfree 5, pctused 90
the answer is choice b).
I could not understand why, as I know that only hard threshold is pctfree + pctused < 100.
in this question, choice a) and b) looks similar.
choice d) may be appropriate for read-only table
choice c) may be appropriate for table whose data changed frequently.
may anyone explain?
