How can you determine if an index needs to be dropped and rebuilt?
- 0 Answers
- 302 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
What does an oracle dba do?
A dba had to remove some archivelogs to free up space in filesystem. Nowwhen the rman job starts to backup archivelogs, it complains about missing archivelogs thatwere deleted by dba. To resolve the issue and continue backing up remainder of archivelogs,which rman command can be used so it wo not complain about missing archivelogs.
How many types of dba are there?
A tablespace has a table with 30 extents in it. Is this bad? Why or why not.
What are the different types of backup available in the oracle?
How can you determine if an index needs to be dropped and rebuilt?
Explain the wait events in statspack report 'db sequential real'?
What is the difference between truncate and delete? How would a full table scan behave after?
What is ora-1555 snapshot too old error? Explain in detail?
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?
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 are the main functions of dba?
Oracle General 
