Process running within Oracle?

[Guest_imported]

Hello

Could someone tell me how I can find out if a process we have is still running within oracle?

Is there some SQL that can do this or is it through unix with a ps -ef | grep <name of process>??

Thanks

Thiko!

 

[Nebuchednezzar]

If you know what the unix pid is/was, you can run this query...
select s.username, s.osuser, s.status, s.sid, s.serial#, p.pid
from v$session s, v$process p
where s.paddr = p.addr
and p.spid = &system_id;

If you get a return sid, the process is still running. (be sure you aren't using the parent pid process, but the unix pid that corresponded to the sqlplus child process).

 

[Guest_imported]

Hi,

Try this query from sql prompt.

Select sid,serial#,substr(machine,1,20) from v$session where status = 'ACTIVE' ;

It will work.