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

18 votes294 views3 answers
Mysql add column with default value
SQL
24 votes316 views4 answers
Postgres delete database
SQL
49 votes357 views6 answers
Mysql add column to table
SQL
0 vote320 views1 answer
Psql check table fields
SQL
2 votes296 views1 answer
Sql update \
SQL
0 vote319 views1 answer
Mysqldump: error:
SQL
0 vote280 views1 answer
Add colum date in sql
SQL
2 votes264 views3 answers
Mysql cheat sheet
SQL
3 votes287 views1 answer
Oracle apex warn on unsaved changes
SQL
25 votes357 views5 answers
Mysql replace text
SQL