How do I kill a user's session?

From: Calvin Crumrine <Calvin_Crumrine_at_dced.state.ak.us>
Date: Mon, 13 Dec 1999 10:11:24 -0900
Message-ID: <385544DC.8B17825A@dced.state.ak.us>

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 Mon Dec 13 1999 - 13:11:24 CST