以下のようなSQLでみつけられる
select t1.last_active_time,
dbms_lob.getlength(t1.sql_fulltext),
dbms_lob.substr(t1.sql_fulltext,3000,1),
dbms_lob.substr(t1.sql_fulltext,3000,3001),
dbms_lob.substr(t1.sql_fulltext,3000,6001),
t1.sql_text,t1.sql_fulltext,t1.*
from
v$sqlarea t1
where
t1.parsing_schema_name ='スキーマ名'
and
t1.module ='exe名'
order by
t1.last_active_time desc