Oracle Server Manager User's Guide

The Sessions Folder

When you click the Sessions folder tab, the Sessions folder opens and the Session object list and menu appear. The Session object list contains information about the users connected to the database.

The following figure illustrates the Session object list.

Figure 5 - 6. Session Object List

Session Object List

The columns of the Session object list are described below:

SID Session identifier.
Serial # Session serial number, used to uniquely identify a session. In combination with the SID, guarantees that session-level commands are applied to the correct session in the event that the session ends and another session begins with the same session identifier.
Username Oracle username associated with the session.
Schema Name Schema name associated with the user.
OS User Operating system username.
Terminal Operating system terminal name.
Machine Operating system machine through which the user is connected.

Disconnecting a User's Session

To disconnect a user's session, select the session to disconnect from the Session object list and choose Disconnect from the Session menu. The Disconnect Session alert box appears.

The following figure illustrates the Disconnect Session alert box.

Figure 5 - 7. Disconnect Session Alert Box

Restricting or Allowing Sessions

To make the database accessible only to users with the RESTRICTED SESSION system privilege, choose Restrict from the Session menu. Only users with the RESTRICTED SESSION system privilege are allowed to connect. Users already connected are not affected.

To make the database accessible to all users, choose Allow All from the Database menu. All users with the CREATE SESSION system privilege are allowed to connect.

SID	Session identifier.
Serial #	Session serial number, used to uniquely identify a session. In combination with the SID, guarantees that session-level commands are applied to the correct session in the event that the session ends and another session begins with the same session identifier.
Username	Oracle username associated with the session.
Schema Name	Schema name associated with the user.
OS User	Operating system username.
Terminal	Operating system terminal name.
Machine	Operating system machine through which the user is connected.