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

Question Posted / rew

2 Answers
5213 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 is the difference between clustered and non-clustered index? : sql server DBA

0 Answers

Explain the difference between $ORACLE_HOME and $ORACLE_BASE.

3 Answers

When creating a user, what permissions must you grant to allow them to connect to the database?

3 Answers

i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?

0 Answers IBM,

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

2 Answers Mphasis,

What is dbcc? : sql server DBA

0 Answers

what is asm?

0 Answers Oracle,

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

2 Answers TCS,

how can you generate profile of pl/sql applications to identify performance bottlenecks?

0 Answers Oracle,

How do you find out from the RMAN catalog if a particular archive log has been backed-up?

2 Answers IBM,

how can you process messages in order asynchronously?

0 Answers Oracle,

What are the different types of upgrades that can be performed in sql server? : sql server DBA

0 Answers

For more DB Administration Interview Questions Click Here