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

0 vote126 views1 answer
Sqlite löschen einer tabelle
SQL
0 vote133 views1 answer
How to set all the time serveroutput on in oracle sql developer
SQL
0 vote79 views1 answer
Sql count how many times a value appears
SQL
49 votes211 views6 answers
Install mysql ubuntu
SQL
0 vote114 views1 answer
Plpgsql coalesce equivalent for empty string
SQL
1 vote77 views1 answer
Enable mysql slow query log
SQL
0 vote113 views1 answer
Sql clear table
SQL
7 votes133 views6 answers
Group_concat in mysql
SQL
1 vote73 views1 answer
Python escape string for sql
SQL
2 votes144 views3 answers
Postgres json to string
SQL