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