doc

    Name:    sesswait.sql

    Author:  Mark Gurry

    This script lists all waits that are currently occurring on the
    system with counts of how many times each wait has occurred.

#

SELECT event, count(*)
  FROM v$session_wait
 GROUP BY event;