Re: Killing sessions

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
-------------------------------------------------------------------