Oracle Exam 1Z0-888 Topic 5 Question 89 Discussion

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

Question #: 89
Topic #: 5

You are receiving complaints from your application administrators that they are seeing periodic stalls in database response (no queries to any table are returning results for several seconds or longer). You monitor your system and notice that the durations of those stalls correspond to peaks in disk I/O.

Which 2 things should you investigate?

ACheck the rate of change in the status value Aborted_connects and compare to the rate of change in Connections.

BCheck the difference between the InnoDB status values ''Log Sequence number'' and ''Last Checkpoint'' positions then compare that to the total size of the redo log.

CCheck the rate of change in the status value Select_scan and compare to the rate of change in Com_select.

DCheck the difference between the InooDB status values ''Trx id counter'' and ''Purge done for'' and compare to the state substatus of the main ''Main thread''

ECheck the rate of change in the statis value Qcache_hits and compare that to the rate of change of Qcache_not_cached.

Show Suggested Answer

Suggested Answer: B, E

by Adaline at Apr 23, 2024, 11:37 PM

Limited Time Offer

25%

1 years ago

I think we should investigate option B.

upvoted 0 times

...