Re: Simple Newbie question

On Fri, 12 Aug 2005 10:44:47 +0800, "Daniel Kyte" <dk_at_dontknow.com> wrote:

>
>"IANAL_VISTA" <IANAL_Vista_at_hotmail.com> ¦b¶l¥ó
>news:Xns96AFC0898E141SunnySD_at_68.6.19.6 ¤¤¼¶¼g...
>> "Daniel Kyte" <dk_at_dontknow.com> wrote in
>> news:42fbe263$1_2_at_rain.i-cable.com:
>>
>> > How to immediately terminate a transaction? (I just come across 'alter
>> > system kill session' but it doesnt immediate kill any running
>> > transaction of the session)
>> >
>> >
>> >
>>
>> On most *nix system it helps to actually kill the OS process.
>> The KILLed SESSION also need to complete rollback of changed data.
>
>Thx, but how about in Windows?
>

find the thread id with the following sql

select spid from v$process where addr = (select paddr from v$session where sid = <affected session>)

Then use the orakill utility in a dos box with the following statement orakill <oracle_sid> <thread id>

Anyway: one seldom needs to kill sessions and killing sessions is not what a newbie should be starting doing to begin with.

--
Sybrand Bakker, Senior Oracle DBA