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

1 vote138 views1 answer
Use of now() in mysql
SQL
0 vote137 views2 answers
Add new column after in sql
SQL
0 vote161 views1 answer
Sql change column in existing table
SQL
1 vote151 views2 answers
Extract weekday from date in sql
SQL
3 votes162 views1 answer
Select table column in sql
SQL
0 vote141 views1 answer
Find and replace database table phpmyadmin
SQL
1 vote256 views1 answer
How to select department from table
SQL
0 vote169 views1 answer
Insufficient privileges while creating view in sql oracle
SQL
33 votes142 views2 answers
Postgres how to add field created at
SQL
0 vote154 views1 answer
Object of class mysqli_result could not be converted to string
SQL