You look at the dba_rollback_segs view and see that you have a large number of wraps is this a problem?
No Answer is Posted For this Question
Be the First to Post Answer
What is the purpose of the import option ignore? What is its default setting?
How do you use automatic pga memory management with oracle 9i and above?
You see a wait on lms process in statspack, what does that mean?
If a tablespace has a default pctincrease of zero what will this cause (in relationship to the smon process)?
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?
What are the different types of backup available in the oracle?
How much money does a dba make?
What is the difference between raid 5 and raid 10? Which is better for oracle?
What is mutated trigger? In single user mode we got mutated error, as a dba how you will resolve it?
Explain force logging feature in 9i.
How can you determine if an index needs to be dropped and rebuilt?