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

5 votes196 views2 answers
Postgre insert select
SQL
0 vote170 views1 answer
Select mysql limit to 2 decimal places
SQL
27 votes217 views5 answers
Mysql set password for user
SQL
0 vote263 views1 answer
Selecting specific day in colum sql
SQL
0 vote199 views1 answer
Minecraft duping allowed servers
SQL
0 vote199 views1 answer
Horizontal join sqlite
SQL
1 vote221 views1 answer
SQL Integer devision
SQL
2 votes214 views3 answers
Copy data from one table column to another table column in sql
SQL
0 vote243 views1 answer
Delete from table where length sql
SQL
0 vote220 views1 answer
Mysqli_connect using prepare statement
SQL