Figure 2-15 (shown in the next section) shows the total service time of 10 seconds. The service time classification is simply server process (SP) time (9 seconds), background process (BG) time (1 second), all parse CPU time (1 second), and all recursive SQL time (0 second). Most Oracle systems will consume CPU primarily in the server process (SP) category. Chapter 5 provides collection details and the associated service time classification math.

Oracle's Statspack and AWR reports provide the detailed level response-time analysis data. However, the reports are clearly not focused on ORTA. In fact, part of the challenge of using Oracle's reports is to know what not to focus on, so you can avoid needless hours immersed in unproductive work. Once you do a few ORTAs based on these tools, you'll discover that performing such an analysis doesn't take all that long.

Being that OraPub is focused on Oracle performance management, ORTA is obviously foundational. Over the years, various reports and tools focused on response time have been developed and included in the free OSM tool kit. Two key reports are a session-focused report (rtsess.sql) and an instance-focused report (rtsysx.sql). Figures 2-15, 2-16, and 2-17 are actual output from the rtsysx.sql report on a test system. Figure 2-18 is an example from the rtsess.sql script.