Which of the following parameters should be set to limit the number of transactions that can simultaneously make changes to data in a block, and increase the frequency with which Oracle returns a block back on the free list?
-
INITRANS and PCTUSED
-
MAXTRANS and PCTFREE
-
INITRANS and PCTFREE
-
MAXTRANS and PCTUSED
D
Correct answer
Explanation
MAXTRANS limits concurrent transaction access to a data block, while PCTUSED determines when a block returns to the free list for new inserts. Together, they control block contention and space reuse frequency. INITRANS sets the initial transaction slot reservation, and PCTFREE controls reserved space for updates.