f46umajdynmqy
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: 33.03%
SQL GETS: 41.59%
SQL I/O: 47.09%
SQL READS: 43.43%
Correlations:
+ | PGA memory operation : 0.39
+ | SQL*Net more data from client : 0.34
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 sequential read | 2.75 | 1.07 | 9 |
CPU + Wait for CPU | 3.77 | 0.90 | 27 |