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

1 vote132 views1 answer
Create new index takes long time postgresql
SQL
-1 vote100 views1 answer
What is in operator
SQL
0 vote103 views1 answer
Column ' ' in field list is ambiguous
SQL
0 vote103 views1 answer
SQL Query to delete all the tables in a database
SQL
0 vote107 views1 answer
Dump db only triggers mysql
SQL
0 vote117 views1 answer
Sql values not in another table
SQL
0 vote94 views1 answer
Postgres set default schema
SQL
0 vote99 views1 answer
Add column not null with default value postgres
SQL
0 vote111 views2 answers
Drop tables from local table database postgres
SQL
2 votes103 views1 answer
Mysql ALTER TABLE ADD COLUMN BOOLEAN AFTER DEFAULT "1";
SQL