This preview shows page 1. Sign up to view the full content.
Unformatted text preview: ents.
E. Eight rollback segments.
Answer E is correct. You need to create 8 rollback segments to handle 32 transactions in the
OLTP system. There is the Rule of four to plan rollback segments numbers for OLTP systems.
Take the total number of transactions that will hit the database at any given time, and divide by 4
to decide how many rollback segments to create.
A: It's just wasting of resources to keep one rollback segment for each user.
B: It's not reasonable to create one rollback segment for each transaction.
C: Use the Rule of four to calculate the number of rollback segments.
D: Use the Rule of four to calculate the number of rollback segments.
Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 373
Chapter 8: Managing Database Objects I
A transaction fails and returns an ORA-01562 indicating that there is insufficient space in
the rollback segment. What are two possible causes? (Choose two) Actualtests.com - The Power of Kn...
View Full Document
- Fall '09