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

0 vote158 views1 answer
No suitable driver found for sqlite
SQL
5 votes718 views1 answer
Oracle ora-00054 find
SQL
0 vote150 views1 answer
Sql query use select name inside where clause
SQL
2 votes149 views1 answer
Postgresql create schema in specific database
SQL
0 vote152 views1 answer
Alter check command
SQL
8 votes137 views1 answer
Ltrim sql
SQL
0 vote205 views1 answer
Order by number of character in sql
SQL
0 vote139 views1 answer
Bus source and destination equal to destination and source of another by sql query
SQL
0 vote174 views1 answer
Get initials name in sql
SQL
-1 vote145 views2 answers
First letter capital in mysql query
SQL