Saturday, June 6, 2009

Session Details,Locks,Waits

Session Details

select s.inst_id,s.sid,s.process,s.status,p.spid,
'dd-mon-yyyy hh24:mi:ss '),s.program,s.module,
s.machine from v$session s,v$process p
where s.paddr=p.addr
and p.spid in('13085');

select lmode,request,inst_id,ctime from v$Lock
where sid=63 and inst_id=2 and block>0;


select inst_id,sid,event,wait_time,seconds_in_wait
from v$session_wait where sid=

No comments:

Post a Comment

Java Web Start

Java Web Start provides a browser-independent architecture.. No dependency on Browser make or version for launching forms in EBS.  Java a...