| |
GeekInterview.com > Interview Questions > Oracle > Concepts and Architecture
| Print | |
Question: what is meant by snapshot error? expain it.
|
| March 03, 2007 07:17:33 |
#4 |
| Mohammed Abdul Afroze |
Member Since: Visitor Total Comments: N/A |
RE: what is meant by snapshot error? expain it.
|
Answer:
Avoiding Snap Shot too old error-(oerr ora 01555).
First thing here we understood how is the rbs works.This will work in circular fashion by looping around the reuse of the extents which has been released by the commited transactions.Thus in case of long running queries if the data is change while the query is running rbs created for that change for the long running query.When these extents are reused,while these were still needed by the query this error occurs,because oracle can no longer provided a read consistent image of the data.
To avoid this error.You need to postpone the reuse of the extents.Thus increasing the size of the rbs and the optimal parameter should do the trick.Commiting less often would be another solution.As until transaction is commited rollback segment cannot be reused.And thus reducing the chances of a snapshot too old error. |
| |
Back To Question | |
