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

2 votes151 views1 answer
Sql OR
SQL
0 vote156 views2 answers
Wordpress change url after migration mysql query
SQL
0 vote144 views1 answer
FIND LOWEST SALARY EARNER IN SQL
SQL
0 vote119 views1 answer
Output table plsql
SQL
7 votes125 views1 answer
Append column sql
SQL
0 vote118 views2 answers
Postgresql create role
SQL
0 vote84 views1 answer
How to set field to null in sql
SQL
1 vote155 views1 answer
Create new index takes long time postgresql
SQL
23 votes126 views6 answers
Delete all rows from table sql
SQL
0 vote100 views2 answers
Avg() sql
SQL