InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
What Causes The "snapshot Too Old" Error? How Can This Be Prevented Or Mitigated? |
|
Answer» This is caused by large or long RUNNING transactions that have either WRAPPED onto their own rollback space or have had another transaction write on part of their rollback space. This can be PREVENTED or mitigated by breaking the transaction into a set of smaller transactions or increasing the size of the rollback SEGMENTS and their EXTENTS. This is caused by large or long running transactions that have either wrapped onto their own rollback space or have had another transaction write on part of their rollback space. This can be prevented or mitigated by breaking the transaction into a set of smaller transactions or increasing the size of the rollback segments and their extents. |
|