Populates a table of information on currently executing statements.
Returns table
Field | Type |
---|---|
id | bigint |
session_id | bigint |
sql_stmt | varchar(1024) |
create time | timestamp |
parameters | varchar(1024) |
SELECT * FROM TABLE(SYS_BOOT.MGMT.STATEMENTS());
Note: As of version 6.0, you no longer need to use the preface SYS_BOOT.MGMT.
SELECT * FROM TABLE(STATEMENTS());
'ID','SESSION_ID','SQL_STMT','CREATE_TIME','PARAMETERS'
'4','3','INSERT INTO "SYS_BOOT"."MGMT"."ALL_TRACE"
(SELECT STREAM "EXPR$0"."ERROR_TIME", "EXPR$0"."ERROR_LEVEL", "EXPR$0"."IS_ERROR", "EXPR$0"."ERROR_CLASS", "EXPR$0"."ERROR_NAME", "EXPR$0"."SQL_STATE", "EXPR$0"."MESSAGE", "EXPR$0"."THREAD_ID", "EXPR$0"."SESSION_ID", "EXPR$0"."STATEMENT_ID", "EXPR$0"."GRAPH_ID", "EXPR$0"."NODE_ID", "EXPR$0"."XO_NAME", "EXPR$0"."ERROR_REPORTER", "EXPR$0"."ERROR_SQL", "EXPR$0"."ERROR_BACKTRACE", "EXPR$0"."DATA_ROWTIME", "EXPR$0"."DATA_ROW", "EXPR$0"."SOURCE_POSITION_KEY", "EXPR$0"."PUMP_DB", "EXPR$0"."PUMP_SCHEMA", "EXPR$0"."PUMP_NAME"
FROM STREAM(SPECIFIC "SYS_BOOT"."MGMT"."NAMEDERRORSTREAM"('GLOBAL_ERROR_STREAM')) AS "EXPR$0")','2019-04-08 01:00:26.472','[[]]'
'227','6','SELECT * FROM TABLE(STATEMENTS())','2019-05-02 14:39:39.78','[[]]'
2 rows selected (0.391 seconds)