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 vote222 views1 answer
Sql get table last modified time
SQL
0 vote170 views1 answer
Update having mysql
SQL
4 votes278 views6 answers
Laravel jwt
SQL
2 votes181 views4 answers
Sql query interview questions
SQL
8 votes171 views1 answer
Oracle find text in functions
SQL
-1 vote173 views3 answers
Unknown collation: 'utf8mb4_0900_ai_ci'
SQL
1 vote172 views1 answer
Show all event schedular on mysql
SQL
0 vote168 views1 answer
How to fix mysql stop unexpectedly
SQL
0 vote178 views1 answer
Normalization in database
SQL
9 votes191 views3 answers
Import DB through mysql console
SQL