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.

Answer / kittu

The ora-1555 is too old snapshot. In order to fix this e need to increase undo_retention & undo tablespace size

how can you get actual data change values from previous transactions in oracle?

0 Answers   Oracle,

---

You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?

0 Answers  

---

What authentication modes does sql server support? : sql server DBA

0 Answers  

---

How do you resize a data file?

2 Answers  

---

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

1 Answers  

---

what is the role of dip user in our database?

0 Answers  

---

How do you trace the traffic hitting a sql server? : sql server DBA

0 Answers  

---

CTS int questions: 1.Temperory tablespace corrupted,how to resolve?If you need to recover? 2.In tablespace begin backup mode,Its possible to add the datafile? 3.How to partition the table using Hash partioning,what happened internally? 4.During rman backup,some files are missing Rman will continue the backup? 5.what are the errors occurs frequently? 6.which join method is best?why? 7.how to solve deadlock errors? please reply anyone.... regards siva

2 Answers   CTS,

---

why Datapump is faster than traditional export and import

4 Answers   Mphasis,

---

As a part of your job, what are the DBCC commands that you commonly use for database maintenance?

1 Answers   IBM,

---

how can you connect from 10g user to 11g user??

0 Answers   HP,

---

what is the last version,the release date of that version and fix pack of ibm db2 udb?

0 Answers  

---