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 vote306 views1 answer
Forcefully delete a row in mysql which has references
SQL
1 vote321 views1 answer
Get the User Name and Domain Name from an Email Address
SQL
0 vote308 views1 answer
Sql query to delete row by id
SQL
0 vote341 views1 answer
Sql delete caracter list
SQL
0 vote344 views1 answer
SQL Server dynamic pivot unknown number of columns
SQL
0 vote322 views1 answer
Datagrip go to line
SQL
17 votes370 views3 answers
Postgresql list users
SQL
1 vote319 views1 answer
Mysql is odd
SQL
0 vote322 views1 answer
Function sum(text) does not exist postgres
SQL
0 vote328 views1 answer
Delete * from where id = 1;
SQL