Saturday, June 6, 2009

Session Details,Locks,Waits

Session Details

select s.inst_id,s.sid,s.process,s.status,p.spid,
s.last_call_et,to_char(s.logon_time,
'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');

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

Waits


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

No comments:

Post a Comment