Re: kill off oracle sessions

Ed Lufker пишет в сообщении <7imh70$3j6$1_at_sloth.swcp.com> ...
>Hi All:
>
>
> How would I kill off Oracle sessions from a unix script.

You can obtain UNIX PID of session by

select a.username,a.sid,a.serial#,b.spid from v$session a, v$process b where b.addr=a.paddr
and a.sid = session_id
and a.serial#=session serial

And then, kill this process.

>
>
>
>thanks
>eddie lufker
>
Received on Mon May 31 1999 - 02:08:20 CDT