select * from v$sqlarea t where t.LAST_ACTIVE_TIME >= {ts'2019-01-15 16:38:00'} and t.LAST_ACTIVE_TIME <= {ts'2019-01-15 16:40:00'}
and PARSING_SCHEMA_NAME = 'HBJTCW'
order by t.LAST_ACTIVE_TIME desc
LAST_ACTIVE_TIME:最近的执行时间
PARSING_SCHEMA_NAME:oracle用户名