Skip to content
This repository

HTTPS clone URL

Subversion checkout URL

You can clone with HTTPS or Subversion.

Download ZIP
tree: 62376407a9
Fetching contributors…

Cannot retrieve contributors at this time

file 11 lines (10 sloc) 0.41 kb
1 2 3 4 5 6 7 8 9 10 11
SELECT t2.username, t2.SID, t2.serial#, t2.logon_time
    FROM v$locked_object t1, v$session t2
   WHERE t1.session_id = t2.SID
ORDER BY t2.logon_time;

SELECT sql_text
    FROM v$session a, v$sqltext_with_newlines b
   WHERE DECODE (a.sql_hash_value, 0, prev_hash_value, sql_hash_value) =
                                                                  b.hash_value
     AND a.SID = &sid
ORDER BY piece;
Something went wrong with that request. Please try again.