Find current running sqls in Oracle

Use below script to get the current running sql details.

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;

Output:

SID USERNAME OPTIMIZER_ HASH_VALUE ADDRESS
---------- ------------------------------ ---------- ---------- ----------------
CPU_TIME ELAPSED_TIME
---------- ------------
SQL_TEXT
--------------------------------------------------------------------------------
1993 SYS ALL_ROWS 3727742172 000000041AE77AD8
817728 817753
select sesion.sid, sesion.username, optimizer_mode, hash_
value, address, cpu_time, elapsed_time, sql_text f
rom v$sqlarea sqlarea, v$session sesion where sesion.sql_hash_value = sqlarea.h
ash_value and sesion.sql_address = sqlarea.address and sesion.username
is not null