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
How can you control the amount of free space in your index pages? : sql server DBA
How do you trace the traffic hitting a sql server? : sql server DBA
what are the differences of where and if in SAS?
I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB
Oracle client is not able to connect to Oracle server although tnsnames.ora file has valid enteries. Oracle error message is “ cannot resolve net service name”. Mention any three reasons.
How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
What are the steps you will take to improve performance of a poor performing query?
How do you troubleshoot errors in a sql server agent job? : sql server DBA
how can you communicate with operating system files from oracle?
Why would you use sql agent? : sql server DBA
Explain about your sql server dba experience? : sql server DBA
how can you create a user-defined lock?
What is dcl? : sql server DBA
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?