How would you determine what sessions are connected and what resources they are waiting for? | Oracle DBA

You can use the V$SESSION and V$SESSION_WAIT dynamic performance views.