Hi All,
Couple of questions
(1) How do I relate a Wait event (reference Top 5 Timed Foreground Events in AWR report) to a query may be the culprit of this wait?

(2) How do I find the segments, datafile, block details affected by the above wait event?

(3) How do I find the query casuing the any above wait events in AWR?