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

3 votes328 views1 answer
Sql several or
SQL
0 vote355 views1 answer
Mysql date minus 1 day
SQL
0 vote357 views1 answer
How to select an index in oracle sql
SQL
10 votes349 views1 answer
Oracle all_dependencies
SQL
3 votes332 views1 answer
How to check schema privileges in oracle
SQL
1 vote371 views1 answer
Mariadb.service: main process exited, code=exited, status=1/failure
SQL
24 votes394 views6 answers
Alter table name sql
SQL
19 votes390 views5 answers
Display table in sql
SQL
0 vote390 views2 answers
Sql unique
SQL
0 vote290 views1 answer
Oracle sql replace string in clob
SQL