RE: Killing "Killed" Users

With Jared's method, you are doing the work that PMON does anyway and are killing the runaway/crashed processes and therefore the processes go away in the catalog tables.

But if you kill the process in oracle, you loose the information about the operating system process and then have to wait till PMON gets around to doing a cleanup.

-----Original Message-----

From: Holman, Rodney [mailto:rodney.holman_at_lodgenet.com] Sent: Monday, November 13, 2000 1:20 PM
To: Multiple recipients of list ORACLE-L Subject: 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-----

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