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

5 votes277 views1 answer
Mysql count newlines in field
SQL
31 votes266 views1 answer
Postgresql add column with constraint
SQL
2 votes290 views1 answer
Ifnull postgres
SQL
1 vote260 views1 answer
Sample in sql
SQL
10 votes299 views1 answer
Oracle view dependencies
SQL
1 vote272 views1 answer
Rename table column name in mysql
SQL
8 votes280 views5 answers
Grant permission in postgres
SQL
4 votes340 views2 answers
Sql display today's date
SQL
0 vote294 views1 answer
Select the date 30 days less that the todays date sql request
SQL
0 vote310 views1 answer
Remove mysql from centos 7
SQL