Re: kill sessions...

From: Pablo Sanchez <pablo_at_dev.null>
Date: Mon, 30 Dec 2002 21:22:20 GMT
Message-ID: <Xns92F49233C1E77pingottpingottbah@209.242.64.107>

Tim X <timx_at_spamto.devnul.com> wrote in
news:87n0mpmqwf.fsf_at_tiger.rapttech.com.au:

> With respect to killing oracle sessions - I don't know enough
> (yet!)

Tim,

I agree with what you're saying on using KILL. Most commercial software have signal handlers to catch the signals sent to the processes.

An easy test to answer your question is to use (strace/truss) to attach to the Oracle shadow process, issue it a series of kill's and see what it does.

Of course it's best to do this on a development Instance but then again, you can always do some QA for Oracle. :)

-- 
Pablo Sanchez, High-Performance Database Engineering
http://www.hpdbe.com

Received on Mon Dec 30 2002 - 15:22:20 CST