select v$sql.sql_text,v$sql.first_load_time,v$sql.last_load_time,v$sqlarea.executions,v$sql.fetches
from v$sql,v$sqlarea
where v$sql.HASH_VALUE = v$sqlarea.HASH_VALUE
and v$sql.LAST_LOAD_TIME > to_char(sysdate - 1/24,'yyyy-mm-dd/hh24:mi:ss')
and v$sql.module = 'JDBC Thin Client'
and v$sql.SQL_TEXT like 'update%'
order by v$sql.LAST_LOAD_TIME desc;