7h6kvx22p1mvc
Module:
Oracle Enterprise Manager.Metric Engine
SQL Text:
Security level 1 does not allow gathering SQL text, use level 2 or higher
Other Top Sections:
SQL CPU: 22.94%
SQL GETS: 9.79%
SQL I/O: 58.72%
SQL READS: 58.72%
Correlations:
+ | db file sequential read : -0.40
+ | log file sync : -0.47
+ | enq: CR - block range reuse ckpt : -0.35
+ | enq: TX - index contention : -0.50
Wait events actually found in ASH section of AWR reports:
| Wait Event Name | AVG % of DB Time in SQL | STDDEV % of DB Time in SQL | Count |
|---|---|---|---|
| db file scattered read | 1.05 | 0.00 | 1 |