Oracle Exam 1Z0-888 Topic 8 Question 15 Discussion

Actual exam question for Oracle's 1Z0-888 exam

Question #: 15
Topic #: 8

You are investigating the performance of the server and see this 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?

AIncrease the value of table_open_cache_instances.

BDecrease the value of table_definition_cache.

CDecrease the value of table_open_cache.

DIncrease the value of table_definition_cache.

EIncrease the value of table_open_cache.

FDecrease the value of table_open_cache instances.

Show Suggested Answer

Suggested Answer: A

by Avery at May 09, 2022, 04:50 PM

Limited Time Offer

25%

Off

Get Premium 1Z0-888 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!