Recently executed statements
(SPID, KPID, BATCHID)
| Name | Data Type | Description |
|---|---|---|
| INSTANCEID | long | Instance ID; 0 = non-CE |
| SPID | long | Session process ID |
| KPID | long | Kernel process ID |
| BATCHID | long | Batch ID |
| STARTDBID | long | ID of the database where the batch started |
| STARTDBNAME | string(32) | Name of the database where the batch started |
| LOGIN | string(32) | User login name |
| STARTTIME | time | Start time of statement |
| ENDTIME | time | End time of statement |
| ELAPSEDTIME | long | Elapsed time, in seconds |
| RSQLID | string(20) | RSQL ID; created by Surveillance |
| CPUTIME | long | CPU time, in milliseconds |
| WAITTIME | long | Wait time, in milliseconds |
| MEMUSAGEB | double | Memory usage, in bytes |
| PHYSICALREADS | double | Number of physical reads |
| LOGICALREADS | double | Number of logical reads |
| ROWSAFFECTED | double | Number of rows affected |
| PAGESMODIFIED | double | Number of pages written |
| PACKETSSENT | double | Number of network packets sent |
| PACKETSRECEIVED | double | Number of network packets received |
| BYTESSENT | double | Network bytes sent |
| BYTESRECEIVED | double | Network bytes received |
| PLANSALTERED | long | Number of plans altered |
| ERRORSTATUS | long | Error code, if an error occurred |
| SQLTEXT | string(256) | SQL text preview |
| Attributes: | MDA |
|---|---|
| Minimum database version: | 15.0.3 |