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 vote320 views1 answer
Object of class sendgrid\mail\mail could not be converted to string
SQL
2 votes306 views1 answer
Oracle convert run_duration to number
SQL
0 vote324 views1 answer
Hour differeence in mysql
SQL
0 vote321 views1 answer
ERROR 1396 (HY000): Operation DROP USER failed for 'ananyapam'@'%'
SQL
0 vote303 views1 answer
Mysql select all table that have field names
SQL
3 votes296 views1 answer
Oracle rollback
SQL
0 vote340 views1 answer
Transaction and commit trong sql server
SQL
0 vote295 views1 answer
Download mysql database to excel in android studio
SQL
1 vote338 views1 answer
Mysql view curren querys
SQL
0 vote333 views1 answer
Oracle to_number
SQL