THREADS

<< Click to Display Table of Contents >>

Navigation:  Streaming SQL Reference Guide > Basic Building Blocks > Functions > Built-in Functions > General Management Functions >

THREADS

Previous pageReturn to chapter overviewNext page

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());

 

5_2_indicator

Version 5.2 Feature

As of version 5.2, you no longer need to use the preface SYS_BOOT.MGMT.

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'