Oracle get 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 vote166 views1 answer
Cast for print sql
SQL
5 votes170 views5 answers
Sqlite install python
SQL
1 vote176 views2 answers
Oracle list service names
SQL
1 vote168 views1 answer
Add constraint sql
SQL
15 votes175 views3 answers
Find duplicate keys in mysql
SQL
1 vote185 views3 answers
Coderbyte mysql challenge MySQL challenge, your query should return the informatioi for the employee with the third highest salary.
SQL
2 votes168 views3 answers
Write sql query to find the second highest salary of employee
SQL
0 vote183 views1 answer
Is there any limit of using joins in single mysql query ?
SQL
0 vote263 views1 answer
Copy from one table to another postgres using matching column
SQL
3 votes186 views2 answers
Sqlite print all column names
SQL