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

42 votes429 views6 answers
Sql query duplicate rows
SQL
1 vote366 views1 answer
Mysql check table exists
SQL
4 votes338 views1 answer
Create column mysql terminal
SQL
-1 vote341 views1 answer
Mysql delete duplicate rows except one
SQL
0 vote348 views5 answers
Linq cheat sheet
SQL
0 vote407 views1 answer
Sql check if field is not null
SQL
1 vote367 views1 answer
Quit mysql
SQL
0 vote358 views1 answer
How to read the potentail error messages in ssis package
SQL
0 vote388 views1 answer
Sql select column name like from multiple tables
SQL
1 vote293 views1 answer
Prevent duplicate rows in postgres
SQL