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.