col bar format a15

prompt +------------------------------------+

prompt | Session samples in last 5 Mins |

Prompt +------------------------------------+

session_id,

count(*)

v$active_session_history

session_state= 'WAITING' and

SAMPLE_TIME > sysdate - (5/(24*60))

session_id

count(*) desc;