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 votes173 views1 answer
Revokeprivileges mysql
SQL
0 vote146 views1 answer
NLS_NCHAR_CHARACTERSET
SQL
8 votes158 views1 answer
Oracle alter tablespace add datafile autoextend max size
SQL
0 vote149 views1 answer
Dbms_output sql developer
SQL
1 vote166 views1 answer
Mysql not supported auth mode
SQL
1 vote161 views1 answer
Postgresql can you have null foreign key
SQL
1 vote153 views1 answer
Ef core 5.0 usesqlserver not found
SQL
4 votes185 views1 answer
Alter session set nls_date_format
SQL
0 vote145 views1 answer
Sql server: how to assign value to table variable returned from function
SQL
0 vote150 views1 answer
Procedure excute monthly oracle
SQL