wait events per sqlid | sql performance waits from awr | awr waits sql

SELECT TO_CHAR(BEGIN_INTERVAL_TIME,'DD.MM.YYYY HH24'),event,count(event)  from DBA_HIST_ACTIVE_SESS_HISTORY v1, DBA_HIST_SNAPSHOT v2
    where v2.snap_id = v1.snap_id
        and sql_id = '5zn8cjmc1vs9b'
        and event is not null
          group by TO_CHAR(BEGIN_INTERVAL_TIME,'DD.MM.YYYY HH24'),event
            order by TO_CHAR(BEGIN_INTERVAL_TIME,'DD.MM.YYYY HH24')