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

14 votes181 views1 answer
Oracle alter table add column not null
SQL
1 vote195 views1 answer
How not to sort by average rating
SQL
0 vote170 views1 answer
Error-expression-select-list-not-group-by-nonaggregated-column/
SQL
0 vote198 views2 answers
Postgres isnull
SQL
1 vote204 views1 answer
Oracle drop chain step
SQL
0 vote165 views1 answer
To change the database owner in SQL server
SQL
0 vote163 views1 answer
Sauvegarde complète my sql
SQL
-1 vote171 views1 answer
Export mysql table to file
SQL
0 vote174 views1 answer
Java nosql sort
SQL
10 votes157 views3 answers
Sql limit results
SQL