How to forcibly disconnect users in Oracle

Copyright NOTICE: This article for Bo Master original article, without Bo Master permission not reproduced.

First look at the current process of the target user, note is serial# instead of serial, the introduction of the Internet Missing #:

Select sid,serial# from v$session where username= ' ERP ';

Use this statement to return a list of processes with two numbers per line, and then replace the following SID and serial with a number

Alter system kill session ' Sid,serial ';

For example

Alter system kill session ' 222,123 ';

Multiple rows of records may be returned through the SELECT statement, so the ALTER statement is executed multiple times

How to forcibly disconnect users in Oracle