Oracle 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

6 votes122 views2 answers
Mysql convert timestamp to date
SQL
0 vote182 views1 answer
Replace null value within column mysql
SQL
0 vote123 views1 answer
Tsql cmd exec script from file
SQL
14 votes126 views3 answers
Alter foreign key
SQL
2 votes116 views1 answer
Oracle sql concatenate results into string
SQL
4 votes149 views4 answers
Remove duplicate old value in mysql
SQL
7 votes152 views3 answers
Sql server check if temp table exists
SQL
3 votes126 views2 answers
Funktion LOWER/UPPER sql
SQL
1 vote122 views4 answers
Psql check tables command
SQL
2 votes129 views1 answer
Illuminate\Database\QueryException : SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost'
SQL