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

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

Contribute your Thoughts:

Submit Cancel

Viola

3 days ago

C sounds like the best option to me. Checking for those big spikes in row activity/access is a surefire way to find the culprits.

upvoted 0 times

...

Jeniffer

8 days ago

I think A is the way to go. Sort by low QRTi values? That's counterintuitive, but I guess it makes sense if we're looking for the problem queries.

upvoted 0 times

...

Janna

13 days ago

D is the correct answer. We want to sort the 'Exec' column and look for queries with high QRTi values, as those are the problematic ones causing performance issues.

upvoted 0 times

...

Tamera

15 days ago

I prefer looking for queries with big prolonged spikes in row activity/access graph. It can help pinpoint the problematic queries more effectively.

upvoted 0 times

...

Carri

20 days ago

I agree with Ulysses. It's important to identify queries that are causing performance issues.

upvoted 0 times

...

Ulysses

25 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

...