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

11 votes124 views2 answers
MySQL DISTINCT
SQL
0 vote73 views1 answer
Resolved [java.sql.SQLException: ORA-29977: Unsupported column type for query registration in guaranteed mode ]
SQL
1 vote117 views6 answers
In sql
SQL
0 vote115 views1 answer
Sql composite key
SQL
3 votes143 views1 answer
Oracle apex warn on unsaved changes
SQL
0 vote122 views1 answer
We are intrested to work with your organization
SQL
1 vote120 views3 answers
Epoch to datetime
SQL
8 votes132 views1 answer
See all users mysql
SQL
0 vote122 views1 answer
Mysql add text to existing field
SQL
16 votes109 views1 answer
Sqlserver add column to table
SQL