A user receives the following error while executing a query: ORA-01555: snapshot too old

Question

TuteeHUB · Accepted Answer

Increase the size of the undo tablespace

TuteeHUB · Answer

nPredict one way to avoid such errors in near future.

TuteeHUB · Answer

Increase the size of redo log files

TuteeHUB · Answer

Increase the size of the undo tablespace

TuteeHUB · Answer

Increase the size of the Database Buffer Cache

TuteeHUB · Answer

Increase the size of the default temporary tablespace

1.	A user receives the following error while executing a query: ORA-01555: snapshot too old
A.	nPredict one way to avoid such errors in near future.
B.	Increase the size of redo log files
C.	Increase the size of the undo tablespace
D.	Increase the size of the Database Buffer Cache
E.	Increase the size of the default temporary tablespace
Answer» C. Increase the size of the undo tablespace

Discussion