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 vote149 views2 answers
Restart identity cascade
SQL
1 vote142 views1 answer
Postgres regex remove special characters
SQL
0 vote136 views1 answer
Codeigniter 3 get best-selling products
SQL
17 votes136 views6 answers
Current date in sql
SQL
4 votes117 views1 answer
Sql list users and roles
SQL
-1 vote135 views2 answers
REMOVE DATE FROM DATE TIME SQL SERVER
SQL
-1 vote124 views2 answers
Sql query examples
SQL
1 vote129 views1 answer
Check constraint to check if date greater than todays date
SQL
2 votes158 views2 answers
SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost' (SQL: select * from information_schema.tables where table_schema = laravel and table_name = migrations and table_type = 'BASE TABLE')
SQL
0 vote172 views1 answer
Mysql select random rows large table
SQL