Current Waits

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