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

0 vote306 views1 answer
Mariadb cast null to 0
SQL
0 vote297 views1 answer
Mssql now diff 90 day
SQL
14 votes318 views2 answers
Oracle limit rows
SQL
1 vote300 views1 answer
Sql server datetime vs datetime2
SQL
1 vote307 views1 answer
Right outer vs left outer join
SQL
0 vote278 views1 answer
Sql server is not
SQL
0 vote286 views1 answer
Rollback to name in sql
SQL
10 votes263 views2 answers
Sql where clause multiple values
SQL
0 vote302 views1 answer
Mysql milliseconds
SQL
0 vote287 views1 answer
Turnicate in mysql
SQL