Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Some problem confusing me a long time.
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.
If alter system doesn't work then kill is fine.
Daniel Morgan Received on Fri Jun 21 2002 - 11:05:59 CDT