On large DSS systems where the transactions are relatively few and large, which approach should you use to define the number and size of rollback segments?
A . Smaller and more rollback segments.
B . Fewer and smaller rollback segments.
C. Larger and fewer rollback segments.
D . Larger and more rollback segments.
Explanation:
Answer C: Since there are few concurrent transactions, there are fewer demands on rollback segment header blocks, which should result in us choosing to create fewer rollback segments. However, transactions will probably be much larger and run longer, so we should increase the size of the rollback segments appropriate. Smaller and more rollback segments apply to OLTP standard operations. Of course, there will be a mix for hybrid systems.
No comments:
Post a Comment