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

1 vote214 views2 answers
Datetrunc hour snowflake
SQL
1 vote220 views1 answer
Simple project for database
SQL
0 vote213 views1 answer
Having trouble running COUNT in my INSERT INTO statement
SQL
1 vote226 views1 answer
Mysql get domain from url
SQL
0 vote237 views3 answers
Postgres date difference seconds
SQL
17 votes255 views2 answers
T_sql contains
SQL
0 vote210 views2 answers
Auto increment column in mysql query results
SQL
1 vote221 views1 answer
Oracle enable job
SQL
1 vote213 views2 answers
Postgres copy table from one schema to another
SQL
28 votes231 views4 answers
Delete database mysql
SQL