| |
GeekInterview.com > Interview Questions > Oracle > Database Administration
| Print | |
Question: PCT Free
Answer: What is PCT Free and PCT Used?
What is PCT increase parameter in segment?
What is growth factor? |
| August 08, 2009 18:55:59 |
#3 |
| refakat |
Member Since: August 2009 Total Comments: 1 |
RE: PCTUSED
|
This is the parameter which specify in percent that a block can only used for insert or come in the freelist(list of blocks in segment ready for insert operation) when used space in a block is less than PCTUSED.
Suppose value of pctused is 40% and pctfree is 20% then data can be inserted till 80% of the block directly. And suppose the used space is 60% and some one has perform a delete operation in a row in the same block which brings the used space to 50%.Now one cannot insert any record in the same block unless the used space comes down below 40% i.e. pctused. |
| |
Back To Question | |
