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

Question Posted / rew

2 Answers
4093 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 are the steps you will take to improve performance of a poor performing query?

0 Answers

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

4 Answers Wipro,

the process of adding a cpu in sql server is called..?

2 Answers TCS,

wat is global index and local indes

1 Answers Oracle,

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

7 Answers TCS,

What is RAID and what are different types of RAID configurations?

1 Answers

What is the difference between LMT & DLT?

1 Answers CTS,

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

0 Answers

How do you add a data file to a tablespace?

3 Answers

Which types of backups you can take in Oracle? 2. A database is running in NOARCHIVELOG mode then which type of backups you can take? 3. Can you take partial backups if the Database is running in NOARCHIVELOG mode?

1 Answers

What is the difference between the 2 operating modes of database mirroring? : sql server DBA

0 Answers

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

2 Answers

For more DB Administration Interview Questions Click Here