Oracle running queries sql

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 vote247 views1 answer
Show table columns
SQL
3 votes239 views1 answer
Difference sql vs mysql
SQL
41 votes329 views6 answers
Alter table add column in SQL Server
SQL
0 vote257 views1 answer
How to check xampp mysql password
SQL
0 vote272 views1 answer
Mysql random number between 1 and 100
SQL
-1 vote250 views1 answer
Mysql #1064 error
SQL
0 vote287 views2 answers
Clauses in mysql
SQL
0 vote294 views1 answer
Postgres list all triggers
SQL
0 vote232 views1 answer
Sqlite3 not commit
SQL
2 votes254 views1 answer
SQLSTATE[HY000] [1049] Unknown database
SQL