A user receives the following error while executing a query:
ORA-01555: snapshot too old
Predict one way to avoid such errors in near future.

Question

A user receives the following error while executing a query:
ORA-01555: snapshot too old
Predict one way to avoid such errors in near future.

TuteeHUB · Accepted Answer

Increase the size of the Database Buffer Cache

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 default temporary tablespace

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

Discussion