RE: Killing "Killed" Users

Even as I was hitting the send button I realised that the user in question had been doing a very large delete statement. Obviously it was in the process of undoing all changes. The session has now gone.

Thanks for the reply.

> Lee Robertson
> Acxiom
> Tel: 0191 525 7344
> Fax: 0191 525 7007
> Email: lerobe_at_acxiom.co.uk
>

-----Original Message-----
From: Charlie Mengler [mailto:charliem_at_mwh.com] Sent: 09 November 2000 13:44
To: lerobe_at_acxiom.co.uk
Subject: Re: Killing "Killed" Users

You have the choice between two UGLY alternatives - 1) Wait
2) Bounce the DB

Oracle will eventually cleanup after itself. A few weeks ago I did the same & it took just over an hour for a session to get cleaned off the system. My guess is that it will take approximately the same amount of time to "undo" a session for the amount of time it had been running before it was killed.

HTH & YMMV! lerobe - Lee Robertson wrote:
>
> All,
>
> Oracle 8.0.5
>
> Is there a method of getting rid of the locks or indded the session once
it
> has been marked as killed. We need to get rid of this session without
> bouncing the DB. Any ideas ??
>
> Regards
>
>
> Lee Robertson
> Acxiom
> Tel: 0191 525 7344
> Fax: 0191 525 7007
> Email: lerobe_at_acxiom.co.uk
>
>
>
> The information contained in this communication is
> confidential, is intended only for the use of the recipient
> named above, and may be legally privileged. If the reader
> of this message is not the intended recipient, you are
> hereby notified that any dissemination, distribution or
> copying of this communication is strictly prohibited.
> If you have received this communication in error, please
> re-send this communication to the sender and delete the
> original message or any copy of it from your computer
> system.
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: lerobe - Lee Robertson
> INET: LEROBE_at_acxiom.co.uk
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).

-- 
Charlie Mengler               Maintenance Warehouse  
charliem_at_mwh.com              10641 Scripps Summit Ct   
858-831-2229                  San Diego, CA 92131