sessions Command

Some of the tasks you must perform as the System Administrator require that you shut down 3DSpace or system software. Before doing this you need to know which users are currently using the database.

This page discusses:

User Level

System Administrator

View User Session Information

You can use the Sessions command to view a list of all current users.

sessions;

This command provides output of the form:

USERNAME MACHINENAME PROGRAMNAME
USERNAME MACHINENAME PROGRAMNAME

  • PROGRAMNAME includes the path, executable name, and any command line options being used.

For example:

peter PETESMACHINE c:\enoviaV6R2014\studio\bin\winnt\mql.exe -k

If the executable was started with a shortcut on Windows, the PROGRAMNAME displayed is limited to the first 64 characters.

You must be logged in as the System Administrator to use the Sessions command. If you receive the following error message, access to the table that stores session information was not configured when the system was installed:

Table or View does not exist.

The Oracle Database Administrator must run the following SQL*Plus command:

GRANT SELECT ON "SYS"."V_$SESSION" TO "MATRIX";