This preview shows page 1. Sign up to view the full content.
Unformatted text preview: orrect. By using more extents in the initial rollback segment allocation determined by the MINEXTENTS storage option - you reduce the probability of your rollback
segment extending. Oracle recommends 20 (or more) extents as part of the initial rollback
A: To minimize the probability of your rollback segment extending Oracle recommends 20 or
more extents for the initial rollback segment, not 15.
C: To minimize the probability of your rollback segment extending Oracle recommends 20 or
more extents for the initial rollback segment, not 5.
D: Each transaction uses one rollback segment, not some, so this answer is completely incorrect.
E: There is the Rule of Four to plan rollback segment numbers for OLTP systems. It
recommends to calculate number of rollback segments by dividing the total number of
concurrent transactions that will hit the database at any given time by 4. This rule have nothing
to do with number of users. Also question does not specify exactly that we use OLTP...
View Full Document
- Fall '09