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 vote138 views1 answer
Virtuoso sql query tutorial
SQL
3 votes136 views2 answers
SqlMessage: "Host '192.168.64.1' is not allowed to connect to this MariaDB server
SQL
0 vote138 views1 answer
Mysqli_real_connect(): (28000/1045): Access denied for user 'u0738423'@'www8.aname.net' (using password: YES)
SQL
0 vote152 views1 answer
The fetch keyword oracle
SQL
0 vote127 views1 answer
Postgresql find missing id
SQL
10 votes131 views4 answers
Drop primary key
SQL
0 vote141 views1 answer
Query params sql insert python f string
SQL
57 votes319 views6 answers
Sql alter table
SQL
1 vote136 views1 answer
Mysql select if empty result
SQL
0 vote138 views1 answer
Mysql select where field is a value
SQL