orra 1555 what is this error,why it is occur?

Answers were Sorted based on User's Feedback



orra 1555 what is this error,why it is occur?..

Answer / nirav gajjar

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

orra 1555 what is this error,why it is occur?..

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

Post New Answer

More DB Administration Interview Questions

what is logical system in sap basis

0 Answers  


How do you open a cluster administrator? : sql server DBA

0 Answers  


What are the commands you'd issue to show the explain plan for "select * from dual"?

0 Answers  


What are statistics, under what circumstances they go out of date, how do you update them?

0 Answers  


What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA

0 Answers  






What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA

0 Answers  


What happens on checkpoint? : sql server DBA

0 Answers  


Give two examples of how you might determine the structure of the table DEPT.

2 Answers  


Why would you call update statistics? : sql server DBA

0 Answers  


Explain the difference between a hot backup and a cold backup and the benefits associated with each?

7 Answers   TCS,


How many memory layers are in the shared pool?

3 Answers  


What is dcl? : sql server DBA

0 Answers  


Categories