Oracle 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 vote279 views1 answer
How to drop a trigger in postgresql
SQL
0 vote278 views1 answer
Replace string in whole database mysql stackoverflow
SQL
4 votes251 views1 answer
Mac install mysql
SQL
0 vote266 views1 answer
Docker export psql sql
SQL
1 vote260 views1 answer
GROUP BY clause; this is incompati
SQL
4 votes274 views1 answer
Id primary key auto generated
SQL
0 vote289 views4 answers
Postgresql between month
SQL
0 vote256 views1 answer
Opensuse status MySQL
SQL
1 vote273 views1 answer
Mysql f# examples
SQL
0 vote278 views1 answer
Drop specific row postgresql
SQL