Figure 2-18. Report output from a session-level ORTA based on a single and identifiable Oracle session. The session is waiting primarily for information from the client process, which leads the analyst to suspect issues with the client program or the network communication between the client and server process.

Here's the strange part: both the application user and the Oracle server process are waiting! That is very unusual indeed. If the user has executed a command and is waiting for the command to complete, while at the same time, the associated Oracle server process is waiting to hear from its client process, then there is problem between the two. The two broad problem areas are the network and the client process.

Referring back to my customer, the problem was indeed the client process. We checked the network, and multiple tnsping executions resulted in a very fast and dependable network. I asked my customer what the application was doing. The answer was something like, "Well, it's doing all sorts of very advanced processing related to inventory management." I responded, "I bet it's doing a lot of advanced processing, because that's what you're waiting for!" Armed with this simple session-level response time profile and the underlying SQL, the manager was able to approach the vendor with full confidence that the problem was clearly focused on the application. And guess what? The vendor listened and fixed the problem!