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 vote143 views1 answer
How to fetch highest score in minimum time using mysql
SQL
7 votes165 views3 answers
Postgre describe table
SQL
2 votes162 views1 answer
11:04:35 PM [mysql] Error: MySQL shutdown unexpectedly. 11:04:35 PM [mysql] This may be due to a blocked port, missing dependencies,
SQL
13 votes145 views11 answers
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysql.sock' (2) Ask
SQL
0 vote152 views1 answer
Suse start MySQL
SQL
0 vote161 views1 answer
Mysql workbench download for iinux mint 19.3
SQL
0 vote178 views2 answers
Replace null with 0 in sql
SQL
3 votes170 views2 answers
Sqlite print all column names
SQL
-3 votes165 views1 answer
Remove spaces sql 2008
SQL
1 vote163 views2 answers
Mysql trim whitespace
SQL