Provides the SQL text that is currently being executed. The maximum size of the SQL text is tuned by max SQL text monitored. monProcessSQLText requires the enable monitoring, max SQL text monitored, and SQL batch capture configuration parameters to be enabled.
Name |
Datatype |
Attributes |
Description |
|---|---|---|---|
SPID |
smallint |
Session process identifier. |
|
KPID |
int |
Kernel process identifier. |
|
BatchID |
int |
Unique identifier for the SQL batch containing the SQL text. |
|
LineNumber |
int |
Line number in SQL batch. |
|
SequenceInLine |
int |
If the entered line of SQL text exceeds the size of the SQL text column, the text is split over the multiple rows. Each row has a unique, and increasing, SequenceInLine value. |
|
SQLText |
varchar(255) |
null |
SQL text. |
