Lists the computers (programs) that are currently connected to WIMS Databases.

USING:

Typically used by administrators to see who and what is connected to the OPS SQL database.  See List Client Sessions to see only those connections from the OPSSQL.exe program.

BUTTONS:

By default, List Active Sessions only displays connections to OPSROOT.  List All Sessions will display ALL connections to any WIMS Database.

 

NOTES:

Note to ORACLE DBA's:  The OPSROOT user must be granted privledges to V$Session view to use this function.  If users receive the following message:

"Failed to retrieve session list
 You may not have priveldges to access the V$Session view."

Please run the following query against your Oracle database:

GRANT SELECT ON "SYS"."V_$SESSION" TO "OPSROOT"

The above query may require you to be logged in as SYS.