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

1 vote110 views1 answer
Psql kill pid
SQL
2 votes147 views4 answers
Check timezone of mysql database
SQL
0 vote148 views1 answer
Delete data from database sqlite android
SQL
0 vote154 views2 answers
How to display enum value sql server
SQL
0 vote141 views1 answer
Pgsql is not permitted to log in
SQL
0 vote261 views2 answers
Execute stored procedure without db set
SQL
0 vote173 views1 answer
Sort by
SQL
28 votes148 views4 answers
Mysql delete database
SQL
1 vote166 views2 answers
Sql now - 1 day
SQL
9 votes142 views3 answers
Mysql show table column full description
SQL