Sunday, October 31, 2010

Check form active sessions

Select  distinct(s.process) , s.machine
      from gv$session_wait a, gv$session s, gv$process p
      where a.sid=s.sid and s.paddr = p.addr   
      and s.action like 'FRM%' order by s.machine;