Databases Reference
In-Depth Information
Let's launch the snapshots and the report:
CONNECT PERFSTAT/PERFSTAT
EXEC statspack.snap;
CONNECT SH/SH
EXEC Chapter1.Workload;
CONNECT PERFSTAT/PERFSTAT
EXEC statspack.snap;
SQL>@?/RDBMS/ADMIN/SPREPORT.SQL
The newly created report presents a result similar to the previous execution:
There is now a Soft Parse of 99.20 percent.
In this simple example, we have seen how to diagnose a simple problem using Statspack;
as an exercise, try to use the other tools presented using the same test case.
To use AWR and ADDM take a manual snapshot before and after
running the
Workload
procedure.
See also
F
Using bind variables
in
Chapter 4
,
Optimizing SQL Code
F
Minimizing latches using bind variables
and
Tuning resources to minimize latch
contention
in
Chapter 11
,
Tuning Contention