Re: Killing sessions

There's a good white paper called "Killing an Oracle Session" which can be downloaded from http://www.revealnet.com

Best wishes,

Cam White
RevealNet, Inc.

Sven Barzanallana wrote:
>
> Martin Drautzburg wrote:
> >
> > Oracle 7.1.3 under solaris 2.4
> >
> > How can I kill and oracle session. I tried svrmgrm, but sometimes I
> > get a message "cannot.... session marked for kill". In situations like
> > these I kill the unix process which seems to fix the problem. Still I
> > wonder:
> >
> > 1. What trouble am I looking for, when I kill the unix process
> > 2. Is there a cleaner way to kill a session ?
> > --
>
> Sometimes user sessions will remain in the v$session view with
> a status of 'Killed'. I generally remove users by killing all
> their UNIX processes and have never had any adverse effects
> for doing so. This also prevents you from getting 'zombie'
> processes that linger, perhaps chewing up CPU time. When you
> kill a UNIX user process, Oracle detects it is missing and
> rolls back any pending transactions and kills the process.
>
> --
> -------------------------------------------------------------------
> Sven Barzanallana This message has been spam-proofed
> Lead Oracle DBA Send replies to:
> Greyhound Lines, Inc. sbarzan_at_greyhound.com
> -------------------------------------------------------------------
  Received on Wed Jul 16 1997 - 00:00:00 CDT