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 vote155 views1 answer
Check constraint is violated
SQL
2 votes132 views4 answers
How to find 2nd highest salary in mysql
SQL
0 vote151 views2 answers
PostgreSQL having
SQL
2 votes135 views2 answers
Mysqli_real_connect(): The server requested authentication method unknown to the client [caching_sha2_password]
SQL
0 vote129 views1 answer
Csv to sqlite python
SQL
1 vote146 views1 answer
Lpad function in sql oracle
SQL
0 vote136 views1 answer
Mysql procedure between two tables
SQL
0 vote118 views1 answer
Get who is hired in month in sql
SQL
1 vote144 views1 answer
Where to locate set password for mysql
SQL
0 vote155 views1 answer
Sqlalchemy empty table
SQL