____ tells Oracle 10g when to allow more rows to be inserted into the block after the deletion of rows from a block.
A) INITRANS
B) PCTUSED
C) PCTINCREASE
D) PCTFREE

Question

Quizplus · Accepted Answer

PCTUSED parameter in Oracle 10g is used to specify the minimum percentage of used space that a block should have before Oracle considers it for the insertion of new rows after rows have been deleted. This helps in managing the space within blocks efficiently by allowing reuse of space from deleted rows when the used space falls below the specified threshold.

____ Tells Oracle 10g When to Allow More Rows to Be