EM: Databases/SQL > SQL/SELECT Connections

Description

The SQL/SELECT Connections page displays all active SQL/SELECT database connections in real time, providing refresh controls, advanced filtering by user and database, and a detailed grid showing connection type, user name, database, connect time, client host, and total connection count.

Location

EM Navigator → Databases/SQL → SQL/SELECT Connections

Toolbar

Button	Function
	Removes/deletes the selected Active Database Connection(s).
	Refreshes the Active Database Connection list.

Active Database Connections: More Options

The More Options section controls how connection data is refreshed and filtered, allowing manual refresh selection and conditional filtering by user name and database using logical operators to narrow results displayed in the connections grid.

More Options Settings List

Settings	Description
Refresh Rate	Controls how frequently the Active Database Connections grid refreshes, allowing manual updates or selectable second-based intervals to automatically reload connection data without user interaction required.
User Filter	When unchecked, filtering controls are disabled. When checked, filtering fields activate, enabling user-defined criteria to narrow displayed connections results.
Filter Field Selector	The database connection attribute used for filtering results. Value Description Type The connection type to distinguish SQL, SELECT, or other connection categories. User Name Filters by user name associated with each active database connection record entry. Database The database name associated with each active SQL/SELECT connection session record. Connect Time Filters connections based on the exact date and time the database session was established. Client Host Filters by client host name or address initiating the database connection request.
Filter Operator	Selects the comparison method used to evaluate a field against entered value. Value Settings equals Matches records where the selected field value exactly equals the entered value. greater than The selected field value is greater than entered value. less than The selected field value is less than entered value. contains The selected field value contains entered text as substring. regex Filters records using a regular expression pattern, enabling advanced, rule-based text matching in the selected column.
Filter Value Field	Defines the user-specified target value that must match the selected filter column and comparison condition when the filter is applied.
Logical Operator Dropdown	Defines the logical relationship between multiple filter conditions in the filter panel, available options: None, AND, and OR, determine whether additional criteria are ignored, combined with AND, or evaluated with OR logic. Value Description None Selects no option for the control, leaving the related feature inactive and applying no additional behavior. AND Requires all defined filter conditions to be true for a record to appear in results. OR Requires at least one defined filter condition to be true for a record to appear.

Active Database Connections: Column Settings

The column section contains tabular list of active SQL/SELECT connections, showing type, user name, database, connect time, client host, and the current total connection count.

Column Settings List

Value	Description
Type	The connection type indicating whether the session uses SQL, SELECT, or other supported connections.
User Name	The user account associated with the active database connection session currently established in the system.
Database	The database name to which the active connection is currently established for access by session.
Connect Time	The date and time when the database connection session was established for tracking and auditing.
Client Host	The host name or address of the client machine initiating the database connection request source.

Connection Count

Displays the total number of active SQL/SELECT database connections currently listed in the connections grid.

See Also

BBjAdminBase

Connection Pools