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

6 votes110 views2 answers
Foreign key sqlite3 python
SQL
0 vote58 views1 answer
Resolved [java.sql.SQLException: ORA-29977: Unsupported column type for query registration in guaranteed mode ]
SQL
34 votes101 views6 answers
Sql change data type
SQL
6 votes93 views2 answers
Return columns from table sql
SQL
0 vote111 views1 answer
Select list is not in group by clause and contains nonaggregated column codeigniter
SQL
14 votes105 views5 answers
Sql oracle limit
SQL
0 vote103 views1 answer
Oracle sql developer closed connection
SQL
0 vote113 views1 answer
Alter table engine mysql
SQL
0 vote108 views1 answer
Drop view in mysql
SQL
1 vote135 views1 answer
Sql server set variable if exists
SQL