oracle中查看某个时间段的日志的sql

select * from v$sqlarea v where v.LAST_LOAD_TIME <sysdate-2/24 and v.LAST_LOAD_TIME >sysdate-8/24 order by LAST_LOAD_TIME;