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 vote241 views1 answer
Sql server beginning of month
SQL
0 vote203 views1 answer
Sql select column names starting with
SQL
1 vote389 views2 answers
Sql unique rows
SQL
0 vote275 views1 answer
Two inner joins sql
SQL
0 vote211 views1 answer
Mysql update from select on same table
SQL
0 vote204 views4 answers
Creating a comment and reply system PHP and MySQL
SQL
0 vote219 views1 answer
Sql date time query find
SQL
0 vote188 views1 answer
Knex last insert id mysql
SQL
0 vote247 views1 answer
Postgresql find biggest table
SQL
0 vote197 views1 answer
Database xml sql
SQL