You are getting busy buffer waits. Is this bad? How can you find what is causing it?
No Answer is Posted For this Question
Be the First to Post Answer
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?
You look at the dba_rollback_segs view and see that you have a large number of wraps is this a problem?
How can you find out how many users are currently logged into the database?
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.
What is pga_aggregate_target?
How does one coalesce free space?
What is oracle full backup?
What exactly does a dba do?
What do you understand by the term 'system change number (scn)'?
How should a many-to-many relationship be handled?
How many control files should you have?
What is dump destination? What are bdump, cdump and udump?