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

2 votes160 views2 answers
SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost' (SQL: select * from information_schema.tables where table_schema = laravel and table_name = migrations and table_type = 'BASE TABLE')
SQL
3 votes147 views1 answer
Oracle apex call duration
SQL
0 vote139 views1 answer
Optimize sql query
SQL
5 votes132 views1 answer
Oracle scan source ddl
SQL
0 vote228 views1 answer
Mysql delete entire row on condition
SQL
2 votes100 views1 answer
Oracle current date without time
SQL
0 vote139 views1 answer
[object Object]: BY KimbleOne__DeliveryGroup__c, CreatedDate ^ ERROR at Row:1:Column:142 field 'CreatedDate' can not be grouped in a query call
SQL
1 vote139 views1 answer
Sql pick random row
SQL
0 vote130 views1 answer
R2dbc-postgresqldriver dependency
SQL
0 vote136 views1 answer
Sql case sttement with set
SQL