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

0 vote158 views1 answer
Sql delimiter to columns
SQL
1 vote143 views1 answer
Sometimes i cant edit sql developer
SQL
0 vote144 views1 answer
Object of class mysqli_result could not be converted to string
SQL
1 vote144 views1 answer
SQL query to get all table records count from a database
SQL
10 votes148 views4 answers
Mysql one week ago
SQL
0 vote151 views1 answer
Sql query to find difference between total no. of rows and distinct rows in sql server
SQL
1 vote145 views3 answers
Sql select only time from datetime
SQL
11 votes141 views3 answers
Sqlite3 create table from another table
SQL
0 vote136 views1 answer
MySQLdb._exceptions.ProgrammingError: (1146, "Table 'edxapp.app_feedback feedback category' doesn't exist")
SQL
0 vote146 views1 answer
Renombrar tabla mysql
SQL