Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Some problem confusing me a long time.

Re: Some problem confusing me a long time.

From: Daniel Morgan <dmorgan_at_exesolutions.com>
Date: Fri, 21 Jun 2002 16:05:59 GMT
Message-ID: <3D134ED3.BB5FE425@exesolutions.com>


xyz wrote:

> 1.
> On metalink,I was told to use "alter system kill session" at Database level
> before using "kill -9 spid" at os levelĄŁ
> But our local Oracle Supporting Engineers told me to use
> "kill -9 spid" on os level because the latter is more thorough.
> Who is right?
> 2.
> After I used the first method to kill some inactive sessions, I cannot find
> the spid's in v$process, and all the PADDR's of "killed" session are the
> same. Why?
> 3.
> I found some sessions marked "SNIPED". Our local Oracle Supporting Engineers
> told me the SNIPED sessions are the sessions that had reached their resource
> limits in their profiles, and I must use
> "kill -9 spid" at os level periodically. Why cannot the oracle background
> process PMON clear the "SNIPED" processs?
> Thanks in advance.

  1. Oracle. Your local engineer believes in killing a mosquito with a thermonuclear weapon.

If alter system doesn't work then kill is fine.

Daniel Morgan Received on Fri Jun 21 2002 - 11:05:59 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US