6muh5fggyvmk3
Module:
XXXX.Services.Cache.Promotions.App.exe
SQL Text:
Security level 1 does not allow gathering SQL text, use level 2 or higher
Other Top Sections:
SQL CPU: 18.65%
SQL I/O: 20.80%
SQL GETS: 20.18%
SQL READS: 20.49%
Correlations:
+ | db file sequential read : 0.64
+ | enq: TX - row lock contention : 0.39
+ | row cache mutex : 0.35
+ | direct path read : 0.54
+ | enq: CR - block range reuse ckpt : 0.39
+ | enq: RO - fast object reuse : 0.42
+ | log file switch (private strand flush incomplete) : 0.57
+ | latch: redo allocation : 0.45
+ | undo segment extension : 0.61
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 |
|---|---|---|---|
| CPU + Wait for CPU | 1.76 | 0.02 | 2 |