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 vote208 views3 answers
Classement rang mysql 7
SQL
0 vote208 views1 answer
Updating database in sql
SQL
0 vote148 views1 answer
Mysql cdn link
SQL
0 vote192 views1 answer
How to pass list as parameter in SQL query
SQL
2 votes148 views1 answer
Oracle number to percentage
SQL
1 vote157 views2 answers
How to enable error squiggles in vs code
SQL
2 votes178 views1 answer
Cannot return non-composite value from function that returns composite type
SQL
0 vote168 views1 answer
Create table using the clause with as
SQL
0 vote168 views1 answer
Create tables from xsd to sql server database c#
SQL
0 vote151 views1 answer
Can't connect to postgresql mac os
SQL