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) |
SELECT * FROM TABLE(SYS_BOOT.MGMT.SESSIONS());
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','','',''