dvtr3uwuqbppa

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 NameAVG % of DB Time in SQLSTDDEV % of DB Time in SQLCount
enq: TX - row lock contention7.763.6974
db file sequential read4.310.9018