Oracle running queries sql

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

1 vote176 views1 answer
Oracle stop
SQL
0 vote160 views1 answer
Wordpress sql find and replace
SQL
0 vote177 views1 answer
Sql server bool select
SQL
1 vote196 views1 answer
Vagrant mysql downgrade version
SQL
1 vote213 views1 answer
OSError: mysql_config not found
SQL
4 votes168 views2 answers
Postgresql default value
SQL
-1 vote165 views1 answer
Window functions in sql
SQL
0 vote185 views1 answer
Sql last time database was accessed
SQL
0 vote178 views1 answer
Tablas bootstrap responsive sql server para datos vivos
SQL
12 votes177 views6 answers
Between in sql
SQL