Real Application Testing - Expert Oracle RAC Performance Diagnostics and Tuning - page 131

Figure 15-22. OEM—SQL Performance Analyzer options

■ although spa is a similar testing tool to database replay, there is an important difference as well: spa can be
run in its own session, which allows you to run it against the actual database but under controlled conditions.

Note

Workshop
To verify the performance of an SQL statement or a set of SQL statements, it's important to capture an SQL tuning
set. The capture can be performed either from the current production environment or from the test/preproduction
environment. Figure 5-23 illustrates the SQL set capture process.

Figure 5-23. OEM—SQL Tuning Set creation