doc

    Name:    userwait.sql

    Author:  Mark Gurry

    This script lists all waits that are currently occurring on the
    system and which users are currently waiting.

#

select ses.username || '('||sw.sid||')' users, event
  from v$session ses, v$session_wait sw
 where ses.sid = sw.sid;