SESSIONS

<< Click to Display Table of Contents >>

Navigation:  Streaming SQL Reference Guide > Basic Building Blocks > Functions > Built-in Functions > General Management Functions >

SESSIONS

Previous pageReturn to chapter overviewNext page

Returns information on the current session

Returns table

Field

Type

id int

url varchar(128)

current_user_name

varchar(128)

current_role_name

varchar(128)

session_user_name

varchar(128)

system_user_name

varchar(128)

system_user_fullname

varchar(128)

session_name

varchar(128)

program_name

varchar(128)

process_id

int

catalog_name

varchar(128)

schema_name

varchar(128)

is_closed

boolean

is_auto_commit

boolean

is_txn_in_progress

boolean

label_name

varchar(128)

Syntax

SELECT * FROM TABLE(SYS_BOOT.MGMT.SESSIONS());

 

5_3_indicator

Version 5.3 Feature

As of version 5.3, you no longer need to use the preface SYS_BOOT.MGMT.

Example

SELECT * FROM TABLE(SYS_BOOT.MGMT.SESSIONS());

 

'ID','URL','CURRENT_USER_NAME','CURRENT_ROLE_NAME','SESSION_USER_NAME','SYSTEM_USER_NAME','SYSTEM_USER_FULLNAME','SESSION_NAME','PROGRAM_NAME','PROCESS_ID','CATALOG_NAME','SCHEMA_NAME','IS_CLOSED','IS_AUTO_COMMIT','IS_TXN_IN_PROGRESS','LABEL_NAME','CLIENT_UUID','SESSION_ID'

'2','jdbc:sqlstream:engine:','MDR','','MDR','sqlstream','','NodeManager','','0','LOCALDB','','false','false','false','','',''

'3','system:','sa','','sa','sqlstream','','SYS_BOOT.MGMT.GLOBAL_TRACE_PUMP_Pump','[pump]','0','LOCALDB','','false','true','true','','',''

'5','jdbc:sqlstream:engine:','sa','','sa','sqlstream','','WebAgent:sqlstream@Home-Comp','','0','LOCALDB','','false','true','true','','',''

'28367','jdbc:sqlstream:engine:','sa','','sa','sqlstream','','sqllineClient@/dev/pts/19:drew@Home-Comp','','0','LOCALDB','','false','true','true','','',''

'48040','jdbc:sqlstream:engine:','sa','','sa','sqlstream','','sqllineClient@/dev/pts/20:drew@Home-Comp','','0','LOCALDB','','false','true','false','','',''