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 vote137 views1 answer
How can I tell how many Cores SQL Server is actually using?
SQL
0 vote255 views1 answer
How to connect .sql data set to powerbi
SQL
0 vote164 views1 answer
Sql to search who modified
SQL
0 vote116 views1 answer
Sql change default collation to utf8
SQL
0 vote119 views1 answer
Insert value list does not match column list: 1136 Column count doesn't match value count at row 2"
SQL
5 votes127 views1 answer
Oracle list days between two dates
SQL
51 votes185 views6 answers
Opera gx
SQL
0 vote128 views1 answer
Snowflake drop column
SQL
0 vote110 views1 answer
Mysql export and import
SQL
0 vote125 views1 answer
PostgreSQL types and C# types
SQL