KILL CONNECTION
Terminates
the connection of a user logged on to a database.
SYNTAX
| connection_ID |
Connection
number that you want to kill. |
DESCRIPTION
The KILL
CONNECTION command terminates a user connection to a database to prevent
the user from performing further database operations. To execute the KILL
CONNECTION command, you must have DBA or SYSADM security privileges.
Executing
this command frees all lock resources held by this user. You may want
to use this command when a user is holding resources needed by other users
for high priority operations, or when the Database Administrator must
shut down the database and all users have not logged off.
EXAMPLE
The following
example kills the connection for the user whose connection ID is 12345.
RELATED COMMANDS
<
INSERT | Contents
| LOAD STATISTICS >
|
