Interested to Buy Any Domain ? << Click Here >> for more details...
orra 1555 what is this error,why it is occur?
- 2 Answers
- 5336 Views
- Mphasis, I also Faced
- E-Mail Answers
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 benefits of flashback feature?
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
In what script is "snap$" created? In what script is the "scott/tiger" schema created?
Where would you look for errors from the database engine?
How would you best determine why your MVIEW couldn't FAST REFRESH?
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
what is grd?
What the different components in replication and what is their use? : sql server DBA
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
what functionality does oracle provide to secure sensitive information?
what are the differences of where and if in SAS?
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
Where do you find the default index fill factor and how to change it? : sql server DBA
