ALTER SYSTEM

Use the ALTER SYSTEM statement to dynamically alter your Oracle Database instance.

Example 1:

SELECT SID,SERIAL# FROM V$SESSION WHERE USERNAME='username';
ALTER SYSTEM KILL SESSION 'session-id,session-serial';