orra 1555 what is this error,why it is occur?
Answers were Sorted based on User's Feedback
The "ORA-01555 snapshot too old" error, which causes user
transactions to fail, is a nightmare for Oracle DBAs and
developers. It usually occurs after queries or batch
processes have been running for a long time, which means
you can lose many hours of processing when the error crops
up.
Is This Answer Correct ? | 5 Yes | 0 No |
Answer / kittu
The ora-1555 is too old snapshot. In order to fix this e need to increase undo_retention & undo tablespace size
Is This Answer Correct ? | 2 Yes | 2 No |
what is logical system in sap basis
How do you open a cluster administrator? : sql server DBA
What are the commands you'd issue to show the explain plan for "select * from dual"?
What are statistics, under what circumstances they go out of date, how do you update them?
What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA
What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA
What happens on checkpoint? : sql server DBA
Give two examples of how you might determine the structure of the table DEPT.
Why would you call update statistics? : sql server DBA
Explain the difference between a hot backup and a cold backup and the benefits associated with each?
How many memory layers are in the shared pool?
What is dcl? : sql server DBA