| pct free and pct used ???? [message #235986] |
Tue, 08 May 2007 10:52  |
gaur_poonam
Messages: 20
Registered: April 2007
Location: India
|
Junior Member |
|
|
Here is a question taken straight from the Couchman text CD. I cant understand why the correct answer is given. I understand the meanings of pctfree / pctused, but I don't know which one is the least desirable:
"Which of the following choices identifies block space utilization settings that are never appropriate under any circumstances:
A: pctfree 5, pctused 90
B: pctfree 20, pctused 70
C: pctfree 15, pctused 80
D: pctfree 10, pctused 40
The correct answer is C. Why ? (I chose B)
Thanks..........
|
|
|
|
|
|
|
|
| Re: pct free and pct used ???? [message #236117 is a reply to message #235986] |
Wed, 09 May 2007 01:27  |
user82
Messages: 49
Registered: June 2006
Location: Romania
|
Member |
|
|
For Michel Cadot.....
and also
A: 90 + 5 = 95 <100
B: 70 + 20 = 90 <100
D: 40 + 10 = 50 <100
.....
isn't it??? Could you explain this in detail...i knew the fact that PCTFREE+PCTUSED < 100 but according to this all the answers are correct...
|
|
|
|
|
|
| Re: pct free and pct used ???? [message #236201 is a reply to message #235986] |
Wed, 09 May 2007 05:05 |
hotmercury
Messages: 13
Registered: February 2007
Location: Mumbai
|
Junior Member |
|
|
|
Heres something from the docs..."The smaller the difference between 100 and the sum of PCTFREE and PCTUSED (as in PCTUSED of 75, PCTFREE of 20), the more efficient space usage is, at some performance cost." Now, i cant see y option C would be the most inappropriate under any circumstances...!!!
|
|
|
|
|
|
|
|
|
|
| Re: pct free and pct used ???? [message #236258 is a reply to message #235986] |
Wed, 09 May 2007 07:45 |
hotmercury
Messages: 13
Registered: February 2007
Location: Mumbai
|
Junior Member |
|
|
|
Hmmm....how about someone telling me the advantage of keeping the PCTUSED set to a low value..(eg: 40)... Wdnt setting a high value be a better option as the inserts are done more frequently...(ie; less than the PCTUSED..)
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
...Michel where r u...!! How abt commenting on this.....