select distinct j1.sql_id, j1.sql_text from v$sql j1, 
    (
      select distinct t1.sql_id
      from V$ACTIVE_SESSION_HISTORY t1, 
          ( 
          select distinct mutex_identifier
          from V$MUTEX_SLEEP_HISTORY where trunc(sleep_timestamp) = trunc(sysdate) 
          ) t2
      where t1.p1 = t2.mutex_identifier 
    ) j2 
where j1.sql_id = j2.sql_id 

select r.* from 
(
    select distinct to_char(j2.sleep_timestamp, 'DD.MM.YYYY HH24:MI:SS') AS date_and_time, j1.user_io_wait_time, j1.sql_id, j1.sql_text 
    from v$sql j1, 
        (
          select t1.sql_id, t2.sleep_timestamp
          from V$ACTIVE_SESSION_HISTORY t1, 
              ( 
              select mutex_identifier, sleep_timestamp
              from V$MUTEX_SLEEP_HISTORY where trunc(sleep_timestamp) = trunc(sysdate) 
              ) t2
          where t1.p1 = t2.mutex_identifier 
        ) j2, 
        (
          select sql_id, count(*) as cnt 
          from v$active_session_history
          where event = 'cursor: pin S wait on X'
          group by sql_id
        ) j3 
    where j1.sql_id = j2.sql_id 
      and j1.sql_id = j3.sql_id 
    order by j1.user_io_wait_time desc 
) r
where rownum <= 10