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

1 vote215 views1 answer
Wherein mysql
SQL
1 vote205 views1 answer
T-sql find object by name
SQL
0 vote238 views1 answer
Mysql date without time
SQL
0 vote200 views1 answer
Postgres full text search example
SQL
1 vote216 views3 answers
Drop unique key constraint in sql server
SQL
0 vote212 views1 answer
How to check event scheduler status mysql
SQL
0 vote205 views3 answers
Mysql delete if not in another table
SQL
0 vote212 views1 answer
Selecting from a view SQL
SQL
0 vote221 views1 answer
Symfony\Component\Debug\Exception\FatalThrowableError : Class 'Doctrine\DBAL\Driver\PDOSqlite\Driver' not found
SQL
17 votes226 views4 answers
Postgres list users
SQL