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

13 votes269 views3 answers
Insert mysql ifile nto database
SQL
18 votes258 views3 answers
Find column name in database
SQL
0 vote247 views3 answers
Get count of null in column sql
SQL
8 votes260 views1 answer
Unique vs primary key
SQL
8 votes257 views1 answer
Oracle all_source package body
SQL
22 votes249 views3 answers
Join three tables sql
SQL
0 vote265 views2 answers
How do I UPDATE from a SELECT in SQL Server?
SQL
1 vote258 views1 answer
Set autoincrement to 0
SQL
6 votes295 views2 answers
Mysql convert timestamp to date
SQL
1 vote261 views4 answers
Alter schema sql
SQL