LMV_ASYNC_COMPILES

This view shows the queries being compiled.

Column

Description

ID

The unique ID of the compilation task. Can be used to kill the compilation via KILL QUERY COMPILE.

PID

The process ID.

QUERY_TEXT

The query being compiled.

TIME_SINCE_SUBMIT

Elapsed time in seconds since the query was submitted.

STATUS

Status of the query.

Last modified: January 22, 2024

Was this article helpful?