1Z0-083 · Question #212
In a recent Automatic Workload Repository (AWR) report for your database, you notice a high number of buffer busy waits. The database consists of locally managed tablespaces with free list managed…
Sign in or unlock 1Z0-083 to reveal the answer and full explanation for question #212. The question stem and answer options stay visible for context.
Question
In a recent Automatic Workload Repository (AWR) report for your database, you notice a high number of buffer busy waits. The database consists of locally managed tablespaces with free list managed segments. On further investigation, you f ind that buffer busy waits is caused by contention on data blocks. Which option would you consider first to decrease the wait event immediately?
Options
- ADecreasing PCTUSED
- BDecreasing PCTFREE
- CIncreasing the number of DBWN process
- DUsing Automatic Segment Space Management (ASSM)
- EIncreasing db_buffer_cache based on t he V$DB_CACHE_ADVICE recommendation
Unlock 1Z0-083 to see the answer
You've previewed enough free 1Z0-083 questions. Unlock 1Z0-083 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.