OBJECTS_IN_USE

<< Click to Display Table of Contents >>

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

OBJECTS_IN_USE

Previous pageReturn to chapter overviewNext page

Syntax

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

 

Returns table

Field

Type

session_id

bigint

stmt_id

bigint

mof_id

varchar(128)

object_name

varchar(128)

5_3_indicator

Version 5.3 Feature

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

Example

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

'SESSION_ID','STMT_ID','MOF_ID','OBJECT_NAME'

'3','4','j:00000000000036FA','ALL_TRACE'

'3','4','j:0000000000003740','NAMEDERRORSTREAM'

'5','48082','j:00000000000036FA','ALL_TRACE'

'5','48085','j:00000000000078B9','guide_1_out_step_1'

'5','48085','j:000000000000787A','guide_1_out_step_0'

'5','48085','j:0000000000007937','guide_1_out'

'5','48085','j:00000000000078F8','guide_1_out_step_2'

'5','48085','j:000000000000783E','data_1'

'5','48085','j:00000000000077F8','data_1_raw'

'28367','48086','j:00000000000026DA','OBJECTS_IN_USE'