SESSIONS

Returns information on the current session Returns table

Field Type
id int url varchar(128)
current_role_name varchar(128)
system_user_name varchar(128)
session_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());

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','','',''