select sql_text,
sql_fulltext,
parsing_schema_name,
module,
last_load_time
from v$sqlarea v
where v.LAST_LOAD_TIME <
to_date('2020/08/18 15:59:56', 'yyyy-mm-dd hh24:mi:ss')
and v.LAST_LOAD_TIME >
to_date('2020/08/18 15:59:53', 'yyyy-mm-dd hh24:mi:ss')
order by LAST_LOAD_TIME;
select sql_text,
sql_fulltext,
parsing_schema_name,
module,
last_load_time
from v$sqlarea v
where v.LAST_LOAD_TIME >
to_date('2021/10/14 13:55:53', 'yyyy-mm-dd hh24:mi:ss')
order by LAST_LOAD_TIME;