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?
No Answer is Posted For this Question
Be the First to Post Answer
What do you understand by a control file?
using hot backup without being in archive log mode, can you recover in the event of a failure? Why or why not?
You have just started a new instance with a large sga on a busy existing server. Performance is terrible, what should you check for?
What is a dba certification?
What happens if the constraint name is left out of a constraint clause?
Who is a database user?
What are the important tasks of common oracle dba?
What will you do if in any condition you do not know how to troubleshoot the error at all and there are no seniors or your co-workers around?
What is dba software?
Users get the following error: ora-00055 maximum number of dml locks exceeded? What is the problem and how do you fix it?
Explain the term 'oracle grid architecture'?
What does a senior database administrator do?