Recent Waits

SELECT event, wait_class, time_waited, session_id
FROM gv$active_session_history
WHERE sql_id = '<your-sql-id>';

Look for:

• db file sequential read: Index access (can be okay)
• db file scattered read: Full table scan
• direct path read temp: Temp usage, probably from a spill
• enq: TX: Locking issues