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 votes119 views4 answers
Describe table postgres
SQL
0 vote128 views1 answer
How to join result table in mysql
SQL
0 vote181 views1 answer
ORA-01400
SQL
15 votes130 views2 answers
Select Options
SQL
34 votes118 views6 answers
Sql change data type
SQL
-1 vote138 views1 answer
Adding a new table psql
SQL
2 votes128 views2 answers
Mysqli_real_connect(): The server requested authentication method unknown to the client [caching_sha2_password]
SQL
16 votes119 views1 answer
Mysql mediumint max value
SQL
3 votes129 views1 answer
Get current month last date in sql server
SQL
0 vote133 views1 answer
Mysql local password denied
SQL