Difference between pages "Check Oracle Blocking Locks" and "Check Oracle Open Cursors by Session"
(Difference between pages)
Jump to navigation
Jump to search
(Created page with "<blockquote><pre> SELECT to_char(sysdate,'yyyy-mm-dd hh24:mi') dttm , ' --- BLOCKER --- ' , lo.session_id , lo.process , lo.os_user_name , dob.object...") |
(Created page with "<blockquote><pre> select o.sid, o.sql_text, o.address, o.hash_value, o.user_name, s.schemaname, o.sql_id from v$open_cursor o, v$session s where o.saddr = s.saddr a...") |
||
| Line 1: | Line 1: | ||
<blockquote><pre> | <blockquote><pre> | ||
| − | + | select | |
| − | + | o.sid, o.sql_text, o.address, o.hash_value, o.user_name, s.schemaname, o.sql_id | |
| − | + | from v$open_cursor o, v$session s | |
| − | + | where o.saddr = s.saddr | |
| − | + | and o.sid = s.sid | |
| − | + | and ( O.SID = &SID) | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
</pre></blockquote> | </pre></blockquote> | ||
Latest revision as of 22:54, 8 November 2019
select
o.sid, o.sql_text, o.address, o.hash_value, o.user_name, s.schemaname, o.sql_id
from v$open_cursor o, v$session s
where o.saddr = s.saddr
and o.sid = s.sid
and ( O.SID = &SID)
