date: “2017-11-19”

draft: false

Returns table of currently executing threads stack entries. Syntax

SYS_BOOT.MGMT.THREAD_STACK_ENTRIES();
Field Type
thread_id bigint
stack_level int
entry_string varchar(1024)
class_name varchar(128)
method_name varchar(128)
file_name varchar(1024)
line_num int
is_native boolean)

Syntax

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

Example

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

0: jdbc:sqlstream:sdp://Home-Comp> SELECT * FROM TABLE(SYS_BOOT.MGMT.THREAD_STACK_ENTRIES());
'THREAD_ID','STACK_LEVEL','ENTRY_STRING','CLASS_NAME','METHOD_NAME','FILE_NAME','LINE_NUM','IS_NATIVE'
'13','0','java.lang.Object.wait(Native Method)','java.lang.Object','wait','Object.java','-2','true'
'13','1','java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:143)','java.lang.ref.ReferenceQueue','remove','ReferenceQueue.java','143','false'