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