Oracle get running queries

SELECT s.SID,
       s.USERNAME,
       sql.OPTIMIZER_MODE,
       sql.CPU_TIME,
       sql.ELAPSED_TIME,
       sql.SQL_TEXT,
       s.SERIAL#
FROM V$SQLAREA sql,
     V$SESSION s
WHERE s.SQL_HASH_VALUE = sql.HASH_VALUE
  AND s.SQL_ADDRESS = sql.ADDRESS
  AND s.USERNAME IS NOT NULL;

Similar codes

1 vote188 views1 answer
Trigger in postgresql to change incoming entry
SQL
3 votes185 views1 answer
Oracle rollback
SQL
4 votes203 views3 answers
Is not null sql
SQL
11 votes196 views3 answers
Python sqlite3 create table if not exists
SQL
0 vote226 views3 answers
Find below average salary in sql
SQL
17 votes212 views2 answers
Mysql date to string
SQL
2 votes239 views1 answer
Match in sql server
SQL
2 votes185 views1 answer
How to select first row of database sql
SQL
1 vote156 views1 answer
Ms sql how to see active job current run time
SQL
0 vote266 views1 answer
Sqlalchemy query return only n results
SQL