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

1 vote220 views1 answer
Sql server reseed single table
SQL
0 vote244 views3 answers
Delete in SQL SERVER
SQL
0 vote238 views3 answers
Classement rang mysql 7
SQL
1 vote180 views1 answer
Unique vs distinct sql
SQL
2 votes246 views2 answers
Postgresql get table names
SQL
0 vote230 views1 answer
Pl/ sql change currency
SQL
1 vote237 views1 answer
Sysdate in sql
SQL
5 votes215 views2 answers
Update all rows mysql
SQL
1 vote245 views1 answer
Oracle get current schema
SQL
2 votes236 views1 answer
Postgresql resolv duplicate value violates unique constraint
SQL