orra 1555 what is this error,why it is occur?
Answer Posted / 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.
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
What are the different types of upgrades that can be performed in sql server? : sql server DBA
What happens on checkpoint? : sql server DBA
what are the performance views in an oracle rac environment?
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
Why would you call update statistics? : sql server DBA
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.
Explain about your sql server dba experience? : sql server DBA
List out some of the requirements to setup a sql server failover cluster.? : sql server DBA
what is the last version,the release date of that version and fix pack of ibm db2 udb?
What is the difference between clustered and non-clustered index? : sql server DBA
What are statistics, under what circumstances they go out of date, how do you update them?
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
Can you redefine a table online?
I have A,B,C servers.i want to 3 servers jobs move to D server(target server)..how? note: i said that take the backup of msdb and restore to the target server..he said while restoring jobs replaced. what is the solution