invantive documentation
Invantive Support ForumsLog In / Sign Up

PooledConnections: SQL Server Pooled Connections

read only

  • Catalog: Database
  • Schema: Invantive
  • Label: Pooled Connections

Can only retrieve data.

Table Columns

The columns of the table PooledConnections are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.

Name Data Type Label Required Marks Documentation
CONNECTION_TIMEOUT_SEC int32 Connection Time-out (sec)
COUNT_TIMES_USED int32 Number of Times Used
CREATED_UTC datetime Date Created
CURRENT_CONTEXT_DESCRIPTION varchar2(240) Current Context Description
CURRENT_CONTEXT_NATURAL_KEY varchar2(240) Current Context Natural Key
CURRENT_CONTEXT_USER_LOG_ON_CODE varchar2(240) Current Context User Log On Code
DATABASE varchar2(240) Database
DURATION_USED_MS int32 Duration Used (ms)
ID int32 ID
IS_FREE char Is Free
LAST_USE_DURATION_MS int32 Last Use Duration (ms)
LAST_USE_END_UTC datetime Last Use End
LAST_USE_START_UTC datetime Last Use Start
ON_CLOSE_SQL_DURATION_MS int32 SQL On Close Duration (ms)
ON_CLOSE_SQL_START_UTC datetime SQL On Close Start (UTC)
ON_CLOSE_SQL_STATEMENT varchar2 SQL On Open Statement
ON_OPEN_SQL_DURATION_MS int32 SQL On Open Duration (ms)
ON_OPEN_SQL_START_UTC datetime SQL On Open Start (UTC)
ON_OPEN_SQL_STATEMENT varchar2 SQL On Open Statement
PREVIOUS_CONTEXT_DESCRIPTIONS varchar2 Previous Context Descriptions
SERVER_VERSION varchar2(240) Server Version
USAGE_PERCENTAGE int32 Usage (%)