Figure 2-17 shows that only two SQL statements had the same first ten characters, and each of these occurs only twice. So it appears that nonbind variable SQL is not an issue. When nonbind variable SQL is an issue, this section may show hundreds of SQL statements with the first 100 characters exactly the same. An equivalent OSM script is simsql1.sql.

Figure 2-17 shows the last section of rtsysx.sql, displaying the operating system CPU utilization details. Starting in Oracle Database 10g, Oracle captures operating system CPU details and makes the information available through the v$osstat view. Chapter 5 provides more details about the v$osstat view, and Chapter 4 discusses the CPU utilization components.

Profiling a session or a group of sessions is another term for session-level ORTA. There are a number of formatting possibilities, with every report writer claiming his is the best. Figure 2-18 shows just one option for this type of report. This format clearly supports ORTA from a high-level classification all the way down to the wait events and service time categories.