select * from v$sqlarea b
where b.FIRST_LOAD_TIME between '2018-07-26/17:00:00' and'2018-07-26/18:30:00'
and upper(b.sql_text) like '%ROLE%'
order by b.FIRST_LOAD_TIME
select * from v$sqlarea b
where b.FIRST_LOAD_TIME between '2018-07-26/17:00:00' and'2018-07-26/18:30:00'
and upper(b.sql_text) like '%ROLE%'
order by b.FIRST_LOAD_TIME