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'