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

Question Posted / rew

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

Query processing is slow(eg select query)how will u solve that

3 Answers TCS,

How can you rebuild an index?

6 Answers

Can we take incremental backups in datapump?

1 Answers

How can we see the database version in os level

6 Answers Oracle,

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

2 Answers IBM,

Q. How to set ORACLE_HOME to my oracle software directory. Hi Friend I am installing oracle 10g Express Edition on Linux Fedora Core 6. Installation is success but when i run #sqlplus I getting command not found error. Then I have search sqlplus .i.e # find / -name sqlplus /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/sqlplus /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/sqlplus These above output from find i have doubt which is correct path of sqlplus. So doubtfully i have set path 1st one.i.e # PATH=$PATH:/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin Then I have run #sqlplus but still i have problem following Error 6 initializing SQL*Plus Message file sp1<lang>.msb not found SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory How overcome this please answer m???

1 Answers

can u plz tell me what r the mandatory skills for getting job as a sql dba......plz send me all details thank you my id :k.mohann.mohan@gmail.com

0 Answers

Should you place Recovery Catalog in the Same DB? . Can you use RMAN without Recovery catalog

4 Answers

What's the benefit of "dbms_stats" over "analyze"?

1 Answers

one datafile is lost in standy side how can you recover that??

2 Answers

1)how to Take Backup in sql server 2005 from Flash Drive

1 Answers

What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA

0 Answers

For more DB Administration Interview Questions Click Here