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

Question Posted / rew

2 Answers
4286 Views
Mphasis, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

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

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 questions might be they ask in managerial round in capgemini.

1 Answers Cap Gemini, iGate,

Explain the difference between ARCHIVELOG mode and NOARCHIVELOG mode and the benefits and disadvantages to each.

5 Answers

Which dictionary tables and/or views would you look at to diagnose a locking issue?

2 Answers

what is difference between user managed backup and rman backup?

1 Answers CTS,

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

2 Answers

How does Oracle guarantee data integrity of data changes?

1 Answers SoftSol,

How will u copy the objects of one schema to another schema in datapump & export/import?

1 Answers

What types of replication are supported in sql server? : sql server DBA

0 Answers

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

0 Answers

How do you resize a data file?

2 Answers

any body know about orawaves do they really provide placements in their unique placement program

1 Answers TCS,

what is meant by gateway

1 Answers IBM,

For more DB Administration Interview Questions Click Here