What is the first thing that you should do to diagnose the cause of the slow response time?

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?

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?

A.
Determine whether it is a memory configuration issue.

B.
Determine whether the slow response is wait bound or CPU bound.

C.
Determine whether the application is performing excessive I/O due to poor access path choice.

D.
Determine whether new tablespaces have been created on the disks that are being used by the
existing tablespaces.



Leave a Reply 1

Your email address will not be published. Required fields are marked *


L. Zhu

L. Zhu

A is wrong. nothing changed
B is right. wait bound or cpu bound
C is wrong.
D is wrong. no change