Oracle
1Z0-883 · Question #21
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…
The correct answer is A. Decrease the value of table_definition_cache. D. Increase the value of table_open_cache. See the full explanation below for the reasoning.
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.
How the community answered
(29 responses)- A72% (21)
- B3% (1)
- E7% (2)
- F17% (5)
Community Discussion
No community discussion yet for this question.