Oracle
1Z0-054 · Question #149
There are 500 users of an online transaction processing (OLTP) application that resides in your database. The system had been maintaining an average response rate of 10 seconds as specified by the…
The correct answer is B. Determine whether the slow response is wait bound or CPU bound. See the full explanation below for the reasoning.
Question
There are 500 users of an online transaction processing (OLTP) application that resides in your database. The system had been maintaining an average response rate of 10 seconds as specified by the Service-Level Agreement (SLA).This morning you were informed that for the past four days the average response time has gone up to 15-20 seconds. No changes have been made to the hardware or networking setup. What is the first thing that you should do to diagnose the cause of the slow response time?
Options
- ADetermine whether it is a memory configuration issue.
- BDetermine whether the slow response is wait bound or CPU bound.
- CDetermine whether the application is performing excessive I/O due to poor access path choice.
- DDetermine whether new tablespaces have been created on the disks that are being used by the
How the community answered
(23 responses)- A9% (2)
- B70% (16)
- C4% (1)
- D17% (4)
Community Discussion
No community discussion yet for this question.