Returns table of currently executing threads.
Syntax
SYS_BOOT.MGMT.THREADS();
Field | Type |
---|---|
thread_id | bigint |
thread_group_name | varchar(128) |
thread_name | varchar(128) |
thread_priority | int |
thread_state | varchar(128) |
is_alive | boolean |
is_daemon | boolean |
is_interrupted | boolean |
SELECT * FROM TABLE(SYS_BOOT.MGMT.THREADS());
SELECT * FROM TABLE(SYS_BOOT.MGMT.THREADS());
'THREAD_ID','THREAD_GROUP_NAME','THREAD_NAME','THREAD_PRIORITY','THREAD_STATE','IS_ALIVE','IS_DAEMON','IS_INTERRUPTED'
'5','system','Signal Dispatcher','9','RUNNABLE','true','true','false'
'22','main','Thread-9','5','RUNNABLE','true','false','false'
'20','main','Thread-7','5','RUNNABLE','true','false','false'
'13','main','Active Reference Queue Daemon','1','WAITING','true','true','false'
'18','main','PumpManagerThread','5','TIMED_WAITING','true','true','false'
'53','main','Thread-37','5','RUNNABLE','true','false','false'
'32','main','Thread-17','5','RUNNABLE','true','false','false'
'3','system','Finalizer','8','WAITING','true','true','false'
'2','system','Reference Handler','10','WAITING','true','true','false'
'30','main','Thread-15','5','RUNNABLE','true','false','false'
'21648','main','AnonymousJavaUdxRel.# 21159:482867','5','WAITING','true','false','false'