Oracle Exam 1Z0-908 Topic 14 Question 93 Discussion

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

Question #: 93
Topic #: 14

[All 1Z0-908 Questions]

You are having performance issues with MySQL instances. Those servers are monitored with MySQL Enterprise Monitor.

Using Query Analyzer, where do you begin to look for problem queries?

ASort the ''Exec' column and check for SQL queries with low Query Response Time index (QRTi) values.

BLook for queries with low total latency times in the Latency section in the times series graph.

CLook for queries with big prolonged spikes in row activity/access graph in the times series graph.

DSort the ''Exec' column and check for SQL queries with high Query Response Time index (QRTi) values.

Show Suggested Answer

Suggested Answer: B, D, E

by Rochell at Oct 20, 2024, 04:05 PM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

3 days ago

I think I would begin by sorting the 'Exec' column and checking for SQL queries with low Query Response Time index values.

upvoted 0 times

...