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

10 votes340 views1 answer
Oracle object dependencies
SQL
0 vote373 views1 answer
What is SQL data store?
SQL
0 vote329 views1 answer
Oracle gather table statistics
SQL
1 vote277 views1 answer
Oracle compile schema
SQL
0 vote336 views2 answers
Don't know how to set rpath on your system, if MySQL libraries are not in path mysql2 may not load
SQL
0 vote348 views3 answers
Select random sql
SQL
0 vote330 views1 answer
Postgresql import a database of gzip
SQL
1 vote381 views1 answer
Sql insert for each distinct value
SQL
1 vote326 views1 answer
How much every mysql database record takes from diskspace
SQL
3 votes356 views2 answers
To_char sql
SQL