Re: kill query w/o killing session?

From: Andreas Sheriff <spamcontrol_at_iion.com>
Date: Tue, 6 Sep 2005 12:06:00 -0700
Message-ID: <sMlTe.71278$Ji4.19456@fed1read03>

"DA Morgan" <damorgan_at_psoug.org> wrote in message news:1125593436.38625_at_yasure...
> Andreas Sheriff wrote:
>
>>>I suspect it will only affect a new transaction but that is a suspicion
>>>worthy of verification. Has anyone done it yet?
>>>--
>>>Daniel A. Morgan
>>>http://www.psoug.org
>>>damorgan_at_x.washington.edu
>>>(replace x with u to respond)
>>
>>
>> I have the same suspicion, but it's also not confirmed.
>>
>> I can try a test Saturday, since the OP doesn't seem interested anymore.
>> I'll post my results to the group.
>
> Thanks ... because I am definitely interested.
> --
> Daniel A. Morgan
> http://www.psoug.org
> damorgan_at_x.washington.edu
> (replace x with u to respond)

The query just kept on running.
The new group only affected new transactions.

Sorry it took so long to post (3-day weekend and all).

-- 
Andreas
Oracle 9i Certified Professional
Oracle 10g Certified Professional
Oracle 9i Certified PL/SQL Developer


"If you don't eat your meat, you cannot have any pudding.
"How can you have any pudding if you don't eat your meat?!?!"
---

WARNING:
DO NOT REPLY TO THIS EMAIL
Reply to me only on this newsgroup

Received on Tue Sep 06 2005 - 14:06:00 CDT