What causes the "snapshot too old" error? How can this be prevented or mitigated?
No Answer is Posted For this Question
Be the First to Post Answer
What are the different responsibilities of a dba?
What is the most important action a dba must perform after changing the database from noarchivelog to archivelog?
When should you increase copy latches?
You look at the dba_rollback_segs view and see that there is a large number of shrinks and they are of relatively small size, is this a problem? How can it be fixed if it is a problem?
using hot backup without being in archive log mode, can you recover in the event of a failure? Why or why not?
Discuss row chaining, how does it happen?
Describe hit ratio as it pertains to the database buffers. What is the difference between instantaneous and cumulative hit ratio and which should be used for tuning?
What is the main function of database?
What are functions of dba?
If you have an example table, what is the best way to get sizing data for the production table implementation?
What are the functions of administration?
How would you find total size of database in os level?