Take a look at the 'alter system kill session' command.
--
Terry Dykstra [TeamPS]
Canadian Forest Oil Ltd.
Harry Yuen wrote in message <354d596a.861398297_at_news.istar.ca>...
>Recently I had to terminate some server running program by means of
>rebooting the client PC. I tried to truncate some tables afterward
>but got a message saying the resource is busy.
>Is there a better way to take care of session killing without getting
>the same effect? As for resource busy, what is available other than
>restarting the instance? Is kiiling a session a DBA only task?
>Thanks in advance.
>
>Harry Yuen
Received on Mon May 04 1998 - 13:42:43 CDT
