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

2 votes271 views1 answer
Copy all values of a column to another column in sql in same table
SQL
0 vote266 views1 answer
Loop through a table variable in TSQL without using a cursor
SQL
13 votes294 views4 answers
Mysql remove foreign key constraint
SQL
0 vote281 views1 answer
Mariadb datetime change to microseconds
SQL
1 vote281 views1 answer
Mysql datetime with timezone offset
SQL
0 vote288 views1 answer
Inserting values with beekeeper get error null value in column createdAt violates not-null constraint
SQL
0 vote267 views1 answer
Sql alter table order by
SQL
0 vote272 views1 answer
Pgsql is not permitted to log in
SQL
6 votes255 views3 answers
Mysql first day of year
SQL
8 votes277 views5 answers
Grant permission in postgres
SQL