28dxvd44z5rwf

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: 47.71%
SQL CPU: 44.65%
SQL I/O: 58.72%
SQL READS: 52.60%

Correlations:
+ | db file sequential read : 0.43
+ | enq: TX - row lock contention : 0.45
+ | read by other session : 0.75
+ | row cache mutex : 0.77
+ | direct path read : 0.59
+ | SQL*Net more data to client : 0.67
+ | PGA memory operation : 0.53
+ | log file switch (private strand flush incomplete) : 0.76
+ | latch: redo allocation : 0.59
+ | Disk file operations I/O : 0.38
+ | undo segment extension : 0.60
+ | SQL*Net more data from client : 0.45

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
read by other session	4.85	0.85	2
CPU + Wait for CPU	5.42	2.44	53