OBJECTS_IN_USE

Syntax

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

Returns table | Field | Type | | — | — | | session_id | bigint| | mof_id | varchar(128) |

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'