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

16 votes143 views3 answers
Update table from another table
SQL
2 votes198 views2 answers
Set value to null sql
SQL
1 vote135 views1 answer
How to select all attributes from a row if there is a certain string in it MySQL
SQL
0 vote78 views1 answer
FindAllBy
SQL
0 vote131 views1 answer
Inserting data into different tables at once in oracle sql
SQL
3 votes145 views5 answers
Sql select
SQL
0 vote166 views1 answer
How to enable mysql 5.7 root user password on linux
SQL
0 vote132 views1 answer
Spring Flyway Teams Edition or MySQL upgrade required: MySQL 5.5 is no longer supported by Flyway Community Edition, but still supported by Flyway Teams Edition.
SQL
1 vote140 views2 answers
Postgresql backup and restore globals and data
SQL
11 votes125 views1 answer
Oracle insert into where
SQL