Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Doubt regarding pctused and pctfree parameter

sandy121Apr 14 2015 — edited Apr 15 2015

Suppose pctused=40 and pctfree = 10 is set for a table, now as per definition, when the usage of the data block reached 40% or higher , block is removed from free list and new rows can't be inserted, but the block has still (90-40) = 50% approx free space ,so new rows can't be inserted there into that 50% free space ?  If new rows can be inserted even if it reached pctused value, how will insert be done as the block will be already removed from free list. Anyone can kindly explain this concept in details. Thanks in advance . I already read documentation on the same but the doubt is still there.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 13 2015
Added on Apr 14 2015
6 comments
355 views