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 vote187 views1 answer
Mysql custom sort order
SQL
0 vote180 views1 answer
Apex for oracle 11g
SQL
0 vote187 views1 answer
Cube oracle
SQL
0 vote172 views4 answers
Postgresql between month
SQL
1 vote211 views1 answer
Mysql print variable
SQL
5 votes177 views3 answers
Sql max value in column
SQL
21 votes181 views3 answers
Search for column name in sql db when i don't know which table it is in
SQL
1 vote175 views1 answer
How to open closed port mysql in ubuntu
SQL
0 vote168 views1 answer
Export partttion and import in oracle
SQL
2 votes177 views2 answers
Run mysql command from bash
SQL