ORACLE user connection management

Use the system administrator to check the number of user connections in the current database: SQL & gt; & nbsp; select & nbsp; username, sid, serial # & nbsp; from & nbsp; v $ session; & nbsp; if you want to stop a connection, use & nbsp; SQL & gt; & nbsp; alter & nbsp; system & nbsp; kill & nbsp; session & nbsp; sid, seri

Use the system administrator to check whether the current database has several user connections:

SQL> select username, sid, serial # from v $ session;

If you want to stop a connection

SQL> alter system kill session sid, serial #;

If this command does not work, find the number of UNIX processes.

SQL> select pro. spid from v $ session ses, v $ process pro where ses. sid = 21 and ses. paddr = pro. addr;

Note: 21 is the number of sid of a connection.

Then run the kill command to kill the process number.