Select sid oracle

Oracle query from sid

-- Sessions, to get SID
SELECT SID, OSUSER, USERNAME, PROGRAM, SERIAL#, INST_ID, STATUS
FROM GV$SESSION WHERE STATUS = 'ACTIVE';
-- Query from selected SID (9999)
SELECT DISTINCT s.PARSING_SCHEMA_NAME AS SCHEMA, c.COMMAND_NAME, s.SQL_TEXT, 
                s.PLAN_HASH_VALUE, t.SQL_ID, t.INST_ID
FROM GV$SQLTEXT t
     JOIN GV$SQL s ON t.SQL_ID = s.SQL_ID
     JOIN DBA_HIST_SQLCOMMAND_NAME c ON t.COMMAND_TYPE = c.COMMAND_TYPE
WHERE t.HASH_VALUE = (SELECT DISTINCT SQL_HASH_VALUE FROM GV$SESSION 
						WHERE SID = 9999);  -- Change SID value

Source: grepper.com

Similar codes

0 vote193 views1 answer
Install sql server windows 10
SQL
13 votes196 views4 answers
Mysql access denied for user 'root'@'localhost'
SQL
4 votes328 views2 answers
Sql display today's date
SQL
4 votes172 views1 answer
Oracle show errors compilation
SQL
0 vote226 views1 answer
. ERROR! The server quit without updating PID file (/usr/local/var/mysql/MacBook-Pro-de-Quentin.local.pid).
SQL
0 vote183 views1 answer
Groupby error in mysql
SQL
6 votes197 views4 answers
Remove spaces sql server
SQL
6 votes251 views3 answers
Rename column ORACLE
SQL
2 votes182 views3 answers
Current month mysql query
SQL
11 votes291 views5 answers
Update table from another table mysql
SQL