Provides the most recent SQL text that has been executed, or is currently being executed. The maximum number of rows returned can be tuned with sql text pipe max messages. monProcessSQLText requires the enable monitoring, max SQL text monitored, SQL batch capture, sql text pipe max messages, and statement pipe active 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 |
|
SequenceInBatch |
int |
Indicates the position of this portion of the SQL text within a batch |
|
SQLText |
varchar(255) |
SQL text |
