Killing (Terminating) a Session

You can use the Oracle Database XE graphical user interface to kill (terminate) a database session. This logs off and disconnects the user running the session. If the user is processing a transaction when you kill the session, the transaction is rolled back.

Reasons to kill a session include the following:

The session is not responding.
You want to perform an administrative function that requires all users to log off first, but the user is not available to end his session.

To kill a session:

View all sessions.

See "Viewing Sessions" for instructions.
Under the SID column, click the session that you want to kill.

The Session Details page appears.
Click Kill Session.

A page appears, prompting you to verify the action.
Click Kill Session again.