select b.SQL_TEXT,b.LAST_ACTIVE_TIME,b.SQL_FULLTEXT
from v$sqlarea b
where module=’xxxxx.exe’
order by b.LAST_ACTIVE_TIME desc
select b.SQL_TEXT,b.LAST_ACTIVE_TIME,b.SQL_FULLTEXT
from v$sqlarea b
where module=’xxxxx.exe’
order by b.LAST_ACTIVE_TIME desc