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

0 vote232 views1 answer
Sql select rows with different values in one column
SQL
17 votes301 views4 answers
Show all tables in oracle
SQL
6 votes224 views1 answer
Sqlite foreign key
SQL
2 votes240 views2 answers
Change varchar length mysql
SQL
3 votes234 views2 answers
Sqlite print all column names
SQL
0 vote276 views1 answer
Postgres list all triggers
SQL
22 votes264 views3 answers
How to join three tables in sql using joins
SQL
0 vote245 views1 answer
Mysql listing get a particu particular user firsdt
SQL
0 vote230 views1 answer
How to set all the min and sec data to zero in sql server
SQL
3 votes248 views1 answer
Oracle list privileges
SQL