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 vote354 views1 answer
How to make sure two tables have same exact data in sql
SQL
0 vote323 views1 answer
T-SQL - Where Used List (Table/View)
SQL
0 vote407 views1 answer
Redshift running queries
SQL
0 vote370 views1 answer
Best practive to pass multiple table to stored procedure in sql server
SQL
0 vote294 views1 answer
Mysql timeout 30 seconds
SQL
0 vote335 views1 answer
Call function sql oracle with output put line
SQL
0 vote356 views1 answer
Postgresql list extensions
SQL
0 vote331 views1 answer
Select multiple row from primary key sql
SQL
2 votes320 views1 answer
Sql server find table name
SQL
0 vote355 views2 answers
Oracle chain rules
SQL