How to Check SQL Running in Oracle Database

DBA scripts to query SQL running in Oracle Database:

select sid, s.SQL_ID,
   s.sql_text,
   v.username,
   v.status, v.action
   from v$session v, v$sqlarea s
   where v.sql_address = s.address
   and v.sql_hash_value = s.hash_value
   AND V.STATUS='ACTIVE'
   /