Re: Determining Oracle Session from PID

Try this:
select s.sid from v$session s, v$process p where s.paddr = p.addr and p.spid = '<UNIX PID>';

Regards,

    Dmitriy Agafonov

> Is there a way to
> determine what the Oracle session is from the process id or in some
> other
> manner so that we can release the lock automatically ???
>
> Thanks,
> Dave
> dwinslow_at_maroon.tc.umn.edu
>
Received on Fri Oct 10 1997 - 00:00:00 CDT