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 vote254 views1 answer
How to order result of subquery in select
SQL
0 vote272 views1 answer
Group by 15 minute interval sql server
SQL
4 votes250 views1 answer
Oracle table statistics last analyzed
SQL
0 vote256 views1 answer
Sql server alter table add column datetime default current_timestamp
SQL
1 vote276 views3 answers
Rows, INSERT INTO
SQL
0 vote267 views1 answer
Mysql query to select the highest value
SQL
3 votes261 views1 answer
Select sequence oracle
SQL
4 votes263 views6 answers
Second max salary in sql
SQL
0 vote262 views1 answer
Sql sum show 0 result
SQL
2 votes291 views3 answers
Xampp mysql database not starting
SQL