How to force disconnect a user in Oracle

In Oracle, the method of disconnecting a user is forced. First, find the current process of the target user. Note that the process is serial # Instead of serial. Some introductions on the Internet are missing #:

In Oracle, the method of disconnecting a user is forced. First, find the current process of the target user. Note that the process is serial # Instead of serial. Some introductions on the Internet are missing #:

In Oracle, the method of disconnecting a user is forced. First, find the current process of the target user. Note that the process is serial # Instead of serial. Some introductions on the Internet are missing #:

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

When this statement is used, a process list is returned. Each line has two numbers, and then the following sid and serial are replaced by a number.

Alter system kill session 'sid, serial ';

For example

Alter system kill session '123 ';

Multiple rows of records may be returned through the select statement. Therefore, the alter statement must be executed multiple times.