EM: Databases/SQL: Databases > Connections
Description
The Connections view provides real-time visibility into active database client sessions, showing connection type, user, connection time, client host, transaction count, executed statements, and the associated connection URL, with filtering and manual refresh controls for monitoring database activity.
Note: selecting a database from
Databases name list, opens its configuration interface, and enabling access to Connections.
Location
EM Navigator →
Databases/SQL →
Databases → Connections
Toolbar
| Button | Function |
|---|---|
|
Deletes/Removes a selected Connection(s) from the list. |
|
|
Refreshes the Connections in the list. |
Connections: More Options
The More Options section controls how connection data is refreshed and filtered, allowing administrators to define refresh behavior and apply conditional filters to narrow displayed connections based on specific criteria such as connection time or user-defined attributes.
More Options Settings
| Settings | Description | ||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
Define how often the connections list refreshes automatically, allowing manual updates or periodic refresh intervals ranging from seconds to one minute. |
|||||||||||||||||
|
|
|||||||||||||||||
|
Allows selecting which connection attribute is used as the primary field for applying filter conditions to the connections table.
|
|||||||||||||||||
|
Defines the comparison rule used to evaluate the selected filter field against the provided filter input value.
|
|||||||||||||||||
|
The comparison value used by the selected filter operator to evaluate and match records in the results table. |
|||||||||||||||||
|
Specifies how multiple filter conditions are combined to determine whether records should be included in the results table.
|
Connections: Column Section
This table lists active database connections, showing connection type, user identity, connection time, client host, transaction count, executed statements, and connection URL.
Column Section Settings
|
The connection type, identifying whether the session is internal, client-based, or established through a specific database access mechanism. |
|
|
The authenticated user name associated with each active database connection session. |
|
|
The timestamp when the connection was established, helping administrators determine session duration and identify long-running or idle connections. |
|
|
The hostname or IP address of the client that initiated the connection to the database server. |
|
|
The total number of database transactions executed by the connection since it was established. |
|
|
The number of SQL statements executed within the connection, providing visibility into query activity and workload intensity. |
|
|
The connection URL used by the client, indicating the database endpoint and parameters applied during session initialization. |
Connection Count
The total number of active connections currently listed in the table.