Re: How do I kill a user's session?

From: Christopher M. Day <christopher.day_at_rdbms.freeserve.co.uk>
Date: Tue, 14 Dec 1999 21:17:57 +0000
Message-ID: <3856B405.FBC500A7@rdbms.freeserve.co.uk>

Calvin,

I'd resolve the SQL*loader problem otherwise you'll be spending all your time killing sessions.

What version of Oracle are you running ?

Chris

Calvin Crumrine wrote:
>
> Running SQL*Loader, a user fails with an internal error that appears to end SQL*Loader without
> unlocking the table.
>
> Since I'm certain similar situations will arise from other actions, my preferred solutions
> would be to kill the user's session, thus freeing up all resources it has locked.
>
> Although I've been designated 'DBA' the only training I was given was before they bought the
> server. By now I've forgotten half of what I was taught, and this might be part of it.
>
> Is there a way to kill a user's session?
>
> Thanks.
Received on Tue Dec 14 1999 - 15:17:57 CST