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 vote324 views1 answer
Sql examples from framework
SQL
6 votes335 views2 answers
Mysql timestamp to date
SQL
0 vote292 views1 answer
Dump only schema
SQL
0 vote321 views1 answer
Leftjoin in sql
SQL
0 vote316 views1 answer
Query archive mode
SQL
7 votes329 views2 answers
Postgres concat
SQL
1 vote326 views3 answers
How to filter repeated same result using sql query
SQL
0 vote311 views1 answer
Sql get guid
SQL
-1 vote324 views1 answer
Partial search in sql
SQL
1 vote315 views1 answer
Set all the vluses in calumn in sql to false
SQL