Certain problems can be avoided, after you know when they occur. The following table lists the problems and their solutions.
|
Problem |
Occurs when |
|---|---|
|
Rollback extension |
A transaction has to extend its size because the current rollback is not large enough to contain all the rollback data |
|
Rollback contention |
There are not enough rollback segments; therefore some transactions requesting rollbacks must wait for a rollback segment |
|
Chaining and dynamic extension |
The current extents assigned to tables, indexes, and rollback segments are insufficient to handle growth |
|
Excessive I/O on hard drives |
Data files are not spread among disks, resulting in degraded performance |
|
Memory paging |
Memory is insufficient to accommodate processing requirements; contributes to excessive I/O on hard drives |
|
Copyright © 2013 CA.
All rights reserved.
|
|