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 vote191 views1 answer
Illuminate\Database\QueryException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'updated_at' in 'field list'
SQL
0 vote179 views2 answers
How to save result of sqlite query in a table
SQL
0 vote184 views1 answer
Influxdb clone measurement
SQL
0 vote144 views1 answer
Grant owner postgresql
SQL
14 votes196 views3 answers
Inner join sql oracle
SQL
2 votes204 views3 answers
Sql server: how to concatenate column data using comma
SQL
0 vote219 views1 answer
Wordpress make wp user in db
SQL
16 votes168 views2 answers
Gremove folder from git
SQL
23 votes165 views3 answers
Mysqldump
SQL
0 vote192 views1 answer
<connectionStrings> <add name="MainDB" connectionString="Data Source=multidc02.its.com.pk,47328;Initial Catalog=ITSGeneralApplications;User ID=ITSGeneralAdmin;Password=TDsHn6TTyJohXCe"/> </connectionStrings>
SQL