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

6 votes274 views4 answers
Rror: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
0 vote242 views1 answer
How do i calculate someone's age based on a datetime type birthday?
SQL
2 votes261 views1 answer
Select from array in psql
SQL
1 vote263 views1 answer
Crontab every month
SQL
0 vote284 views1 answer
Get date from timestamp in mysql
SQL
0 vote258 views1 answer
Sqlite referential integrity
SQL
0 vote288 views1 answer
Alter column to not null with default value sql server
SQL
3 votes276 views1 answer
Kill mysql processlist in whose time more than 200
SQL
0 vote272 views1 answer
Query to count the number of rows in a table in sqlalchemy
SQL
1 vote273 views1 answer
How to find median of a column sql
SQL