REM
REM DBAToolZ NOTE:
REM This script was obtained from DBAToolZ.com
REM It's configured to work with SQL Directory (SQLDIR).
REM SQLDIR is a utility that allows easy organization and
REM execution of SQL*Plus scripts using user-friendly menu.
REM Visit DBAToolZ.com for more details and free SQL scripts.
REM
REM
REM File:
REM c_kill.sql
REM
REM USER MOST
REM
REM Author:
REM Vitaliy Mogilevskiy (vit100gain@earthlink.net)
REM
REM Purpose:
REM
REM KILLS user session (prompts for SID and SERIAL#)
REM
REM
REM Usage:
REM c_kill.sql
REM
REM Example:
REM c_kill.sql
REM
REM
REM History:
REM 12-06-2001 VMOGILEV Created
REM
REM
undefine sid
undefine serial
alter system kill session '&sid,&serial'
/