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 vote229 views1 answer
Minus vs except in sql
SQL
0 vote232 views1 answer
Bidirectional outer join sql
SQL
1 vote228 views1 answer
Sql dcl
SQL
0 vote219 views1 answer
Select STR_TO_DATE(date_seance1,'DD-MM-YYYY')
SQL
-1 vote248 views1 answer
Mysql faster insert
SQL
7 votes219 views1 answer
Mysql iif
SQL
0 vote241 views1 answer
Rows, INSERT INTO, Returning
SQL
1 vote213 views1 answer
Oracle sql assign unique number to each grouping
SQL
1 vote222 views1 answer
Join first name and last name sql
SQL
0 vote206 views2 answers
Postgresql get long running queries
SQL