Oracle
1Z0-883 · Question #21
1Z0-883 Question #21: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-883 to reveal the answer and full explanation for question #21. The question stem and answer options stay visible for context.
Question
You are investigating the performance of the server and see the following information: - Events_waits_summary_global_by_event_name in the performance schema shows that the wait/synch/mutex/sql/LOCK_table_cache event is dominating other wait events. - The table_open_cache_overflows status variable is 0. Which action should be taken to remove the performance bottleneck described here?
Options
- ADecrease the value of table_definition_cache.
- BIncrease the value of table_definition_cache.
- CDecrease the value of table_open_cache.
- DIncrease the value of table_open_cache.
- EDecrease the value of table_open_cache_instances.
- FIncrease the value of table_open_cache_instances.
Unlock 1Z0-883 to see the answer
You've previewed enough free 1Z0-883 questions. Unlock 1Z0-883 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.