sql如下:
select * from v$sqlarea b
where b.FIRST_LOAD_TIME between '2018-08-23/08:30:00' and'2018-08-23/09:00:00'
and upper(b.sql_text) like '%select%'
order by b.FIRST_LOAD_TIME
sql如下:
select * from v$sqlarea b
where b.FIRST_LOAD_TIME between '2018-08-23/08:30:00' and'2018-08-23/09:00:00'
and upper(b.sql_text) like '%select%'
order by b.FIRST_LOAD_TIME