You can view and tune the SQL
statements
and query workloads that
are identified by your normal or exception monitor profiles.
About this task
Before the first consolidation is complete, no information
is available from a monitor profile, even if monitored SQL statements
have
run. At the end of each consolidation interval, information about
the SQL statements that are monitored by each monitor profile is written
to the subsystem. After each consolidation, you can use the to
view, analyze, and tune the monitored SQL statements.
To view the query monitoring result and tune the workload
or individual SQL statements:
What to do next
Analyze and tune the workload as a group or individual
SQL statements
with the
Query Tuner Workflow Assistant.