RE: Killing "Killed" Users

On Mon, 13 Nov 2000, Holman, Rodney wrote:

> Actually Jared's method is what I usually use when I need to kill "killed"
> users. It hasn't hung me yet....

You can do this, as long as you determine the server process PID first, as it will disappear from v$process after you KILL the session.

Jared

>
> Rodd Holman
> Enterprise Data Systems Engineer
> LodgeNet Entertainment Corporation
> rodney.holman_at_lodgenet.com
> Comments made are my own opinions and views. They do not represent views,
> policies, or procedures of LodgeNet Entertainment Corporation
>
> -----Original Message-----
> Sent: Monday, November 13, 2000 11:02 AM
> To: Multiple recipients of list ORACLE-L
>
>
> ... Has anyone else had similar experiences to Jared's?
> Perhaps the stuff I have heard is all "fluff". I'm certainly inclined to
> believe Jared.
>
> My question is this: When Oracle kills the session, what is it killing
> *exactly*?
>
>
> John Dailey
> Consultant
> Concept Solutions, LLC
>
> Concept Solutions, LLC
> *Your Business Intelligence Partner*
> www.concept-solutions.com
>
>
> -----Original Message-----
> Sent: Monday, November 13, 2000 11:26 AM
> To: Multiple recipients of list ORACLE-L
>
>
>
> I've found that the best method for killing session is to
> kill the system process *first*, then kill the Oracle session.
>
> PMON seems to do a better job of cleaning up sessions that way.
> Dunno why, but several years of anecdotal evidence and being
> required to bounce the DB when I didn't kill the process first
> have convinced me.
>
> Jared
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Holman, Rodney
> INET: rodney.holman_at_lodgenet.com
>
> 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).
>
>

Jared Still
Certified Oracle DBA and Part Time Perl Evangelist ;-) Regence BlueCross BlueShield of Oregon
jkstill_at_bcbso.com - Work - preferred address Received on Mon Nov 13 2000 - 19:16:20 CST