RE: Killing "Killed" Users

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

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-----
From: John Dailey [mailto:John.Dailey_at_concept-solutions.com] Sent: Monday, November 13, 2000 11:02 AM To: Multiple recipients of list ORACLE-L Subject: RE: Killing "Killed" Users

... 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 Received on Mon Nov 13 2000 - 12:19:20 CST