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 process messages in order asynchronously?
Query processing is slow(eg select query)how will u solve that
how can you initialize log miner?
i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?
Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit
Why would you use sql agent? : sql server DBA
Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com
how can you generate profile of pl/sql applications to identify performance bottlenecks?
Which autogrowth database setting is good? : sql server DBA
who owns the operating system files created by the utl_file package?
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
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.
what is logical system in sap basis
How to start SQL Server in minimal configuration mode?
how can you connect from 10g user to 11g user??