THREADS

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

Syntax

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

Example

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'