aubnkrv6cz41z
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: 98.17%
SQL READS: 3.06%
SQL GETS: 68.81%
SQL I/O: 5.20%
Correlations:
+ | enq: TX - row lock contention : 0.52
+ | row cache mutex : 0.44
+ | direct path read : 0.58
+ | control file sequential read : -0.35
+ | SQL*Net more data to client : 0.68
+ | log file switch (private strand flush incomplete) : 0.45
+ | latch: redo allocation : 0.36
+ | undo segment extension : 0.46
+ | ASM file metadata operation : -0.44
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 | 10.19 | 8.67 | 260 |