Tuesday, October 11, 2011

How to Determine the Blocking Session for Event: 'cursor: pin S wait on X'

Use this query to determine the Blocking Session for Event: 'cursor: pin S wait on X'

select s.username
, s.sid
, s.serial#
, p.spid pid
, last_call_et
, status
from V$SESSION s
, V$PROCESS p
where s.PADDR = p.ADDR
and sid in (
select to_number(substr(to_char(rawtohex(p2raw)),1,8),'XXXXXXXX') sid
from v$session
where event = 'cursor: pin S wait on X');

1 comment:

Anonymous said...

Merkur 37C Heavy Duty Slant Bar Review
The Merkur 37C Heavy Duty Slant Bar is a chrome 1xbet finished and finished 3-piece double edge safety razor. The blade angle 카지노 is approximately 4″ from Pros and cons include: The 2-piece DE Safety Razor is not too aggressive · The razor has some 메리트 카지노 쿠폰 really nice features · The handle  Rating: 4.3 · ‎Review by Amanda Blain