find current running sqls - Oracle Database Script. SELECT sesion.sid, sesion.username, optimizer_mode, hash_value, address, cpu_time, elapsed_time, sql_text FROM v$sqlarea sqlarea, v$session sesion WHERE sesion.sql_hash_value = sqlarea.hash_value AND sesion.sql_address = sqlarea.address AND sesion.username IS NOT NULL;
SELECT sesion.sid, sesion.username, optimizer_mode, hash_value, address, cpu_time, elapsed_time, sql_text FROM v$sqlarea sqlarea, v$session sesion WHERE sesion.sql_hash_value = sqlarea.hash_value AND sesion.sql_address = sqlarea.address AND sesion.username IS NOT NULL;