1. Categories >> Software >> Databases >> DB Administration
  2. Suggest New Category

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

Question Posted / rew

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 column differentiates the V$ views to the GV$ views and how?

3 Answers  

Give two methods you could use to determine what DDL changes have been made.

2 Answers  

What is the difference between online backup & offline backup?

3 Answers   CSC,

what are the differences of where and if in SAS?

1 Answers  

In oracle 10g export, import if we declare rows=y/n what would be the output?

0 Answers   Value Labs,

What is a deadlock and what is a live lock? How will you go about resolving deadlocks?

1 Answers  

Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down? : sql server DBA

1 Answers  

Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com

0 Answers   Oracle,

Is it possible to run 32 bit sql server 2000 on64bit windows platform.if how much memory is available to sql server?

1 Answers  

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

1 Answers  

now one user in online.now i want drop him..how do u drop him?

4 Answers   Wipro,

I got an error SQL1042C. An unexpected system error occurred. Explanation: A system error occurred. One possible reason for this error is that the database manager is not installed correctly or the environment is not set up correctly. On OS/2, while trying to start the database manager, a very common reason for this error is a corrupted NET.ACC file. The command cannot be processed. The tables and views would not be opened. What is the way to open the dataase? pls help me

1 Answers  

For more DB Administration Interview Questions Click Here
Categories