Multiple choice

Which 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?

  1. INITRANS and PCTUSED

  2. MAXTRANS and PCTFREE

  3. INITRANS and PCTFREE

  4. MAXTRANS and PCTUSED
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

MAXTRANS limits concurrent transactions per block, while PCTUSED determines when a block returns to the free list (when free space falls below this percentage after deletions). Together they control block-level concurrency and space reuse.

Keep practicing — related questions