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

Question Posted / rew

2 Answers
5348 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

How do you increase the OS limitation for open files (LINUX and/or Solaris)?

1 Answers

What is the default fill factor value? : sql server DBA

0 Answers

Which autogrowth database setting is good? : sql server DBA

0 Answers

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

2 Answers

Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA

0 Answers

how can you implement fine-grained auditing?

0 Answers Oracle,

What query tells you how much space a tablespace named "test" is taking up, and how much space is remaining?

1 Answers

How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?

1 Answers

Explain the concept of the DUAL table.

3 Answers

Explian different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?

1 Answers

What would you use to improve performance on an insert statement that places millions of rows into that table?

2 Answers TCS,

what is the purpose of catlaog in oracle rman?

2 Answers Value Labs,

For more DB Administration Interview Questions Click Here