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
Mysql error codeigniter
SQL
16 votes274 views6 answers
This is incompatible with sql_mode=only_full_group_by
SQL
19 votes276 views3 answers
How to change column type psql
SQL
0 vote253 views1 answer
How to order result of subquery in select
SQL
0 vote246 views1 answer
Transalations from sql to Linq count and group by
SQL
3 votes239 views2 answers
Mysql add 2 hours
SQL
-2 votes251 views2 answers
Sqlserver docker
SQL
5 votes259 views1 answer
Purge undo tablespace usage
SQL
8 votes258 views1 answer
Today minus 15 days postgresql
SQL
93 votes324 views4 answers
Create database postgres
SQL