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

8 votes173 views1 answer
Racle create auto increment column
SQL
2 votes134 views2 answers
Sqlalchemy filter or
SQL
0 vote151 views1 answer
Warning: pdostatement::execute(): sqlstate[hy093]: invalid parameter number: number of bound variables does not match number of tokens
SQL
0 vote181 views1 answer
How to check rollback status in oracle
SQL
0 vote139 views2 answers
Uncaught Error: Cannot use object of type mysqli_result as array
SQL
0 vote149 views1 answer
How to move a column to different spot mysql
SQL
2 votes141 views1 answer
Mysql Incorrect column specifier for column
SQL
0 vote136 views1 answer
Sql query to delete row by id
SQL
0 vote141 views1 answer
Aktor yang pernah terlibat di film bergenre Aksi di sql
SQL
0 vote135 views1 answer
Mysql where in keep order
SQL