Database Sessions Monitoring - Intergraph Smart Materials - Version 2020 (10.0) - Administration & Configuration - Hexagon PPM

Intergraph Smart Materials Classic Administration (2020)

Language
English
Product
Intergraph Smart Materials
Subproduct
Classic
Search by Category
Administration & Configuration
Smart Materials/Smart Reference Data Version
2020 (10.0)

The A.60.82 Database Sessions screen can be used to monitor active database sessions.

You can select a view option from the group of options at the top of the screen to filter the displayed sessions. The available options are:

  • All Sessions - (default) All database sessions appear.

  • Active Sessions - Only the sessions with a status of 'ACTIVE' appear.

  • Idle Sessions - Sessions that are either 'INACTIVE' or 'SNIPED' appear.

  • Active BIR Sessions - BIR (Smart Materials Business Intelligence Reporting) sessions with validity time less than SYSDATE appear.

  • Idle BIR Sessions - BIR sessions with validity time greater than or equal to SYSDATE appear.

This screen shows the active database sessions without the ORACLE kernel processes. The SID field of the current session is highlighted with a blue background color.

There are multiple intended purposes of this screen. For example, if users report that their session is hanging, it is possible to identify the database processes to see what is going on. Or, if a user is entering data and gets data access/locking conflicts, he can ask the DBA to tell him if somebody else is working in the same screen at the same time. Or, if the database has to be shut down, the DBA can identify and notify all connected users to log out.

The License Module field might contain other information if it is not a Smart Materials or Smart Reference Data session record. Also, the Application Server field can display other information like the name of the client machine, for example, when working with a development tool against the database.

The super user can display the SQL text of a selected session or activate the milestone transaction loging with a right mouse-click on the SID field.

Selecting Show SQL will open a new window displaying the current select statement of the corresponding session.

Selecting Enable Milestone Transaction Logging will activate the milestone transaction logging. This can be used to analyze problems with the Milestone Tracking, to find out if all tracked date changes are applied to the corresponding planning item (detail) milestones.

A6082RM02

Activating the milestone transaction logging will have a significant impact on the performance. After clicking this option, a warning appears that must be acknowledged with Yes to enable the logging.

Use the button to terminate the related session if it’s hanging and cannot be stopped in the usual way.

Here is a list of the displayed session information:

SID

The session identifier used in the database.

Serial#

The serial number used in the database.

Auditing SID

The auditing session identifier used in the database.

USID

The User Security ID that identifies the login environment.

User

The username that was used to enter the application.

Project/Product Group

The project or product group the user is logged in to.

Discipline

The actual login discipline.

Nls

The actual login language.

Role

The role that is assigned to the user.

Logon Time

The date and time when the user started this session.

Menu Item

The module/screen the user is actually working in.

License Module

The licensed module the user is counted for.

Client IP

The client machine IP address from where the user is connected.

To support IPv6 clients, Smart Materials creates a unique IPv4 (not exactly the IPv4 standard) address and stores it internally for each IPv6 client address. You can identify if a session is from an IPv6 client if the IP address appearing in this field starts with a number greater than or equal to 256.

Client Machine

The client machine name from where the user is connected.

Client User

The client machine OS user from where the user is connected.

Application Server

The name of the used application server. If no application server is used, but the user connects directly from the database console or via SQLNET, the name of the connected client will be displayed.