dvtr3uwuqbppa
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 GETS: 22.02%
SQL CPU: 22.32%
SQL I/O: 34.86%
SQL READS: 34.56%
Correlations:
+ | db file sequential read : 0.65
+ | enq: TX - row lock contention : 0.97
+ | row cache mutex : 0.39
+ | direct path read : 0.50
+ | SQL*Net more data to client : 0.55
+ | log file switch (private strand flush incomplete) : 0.43
+ | undo segment extension : 0.53
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 |
---|---|---|---|
enq: TX - row lock contention | 7.76 | 3.69 | 74 |
db file sequential read | 4.31 | 0.90 | 18 |