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 vote105 views1 answer
Select only one row sql
SQL
4 votes103 views2 answers
Mysql show indexes on table
SQL
1 vote115 views5 answers
Sql 2nd highest salary
SQL
1 vote63 views1 answer
How to run sql script
SQL
2 votes106 views1 answer
Copy all values of a column to another column in sql in same table
SQL
12 votes103 views2 answers
Delete all nodes neo4j
SQL
2 votes96 views1 answer
Oracle sql drop column if exists
SQL
1 vote116 views1 answer
Insert pg result of select
SQL
0 vote106 views1 answer
Mysql command line top 10
SQL
2 votes97 views2 answers
Postgresql date at timezone
SQL