SQL plans for current executing statements
(session_id, request_id, seqno)
| Name | Data Type | Description |
|---|---|---|
| session_id | long | Session ID |
| request_id | long | Request ID |
| sqlid | string(36) | SQL ID; created by Surveillance (based on SQL handle) |
| planid | string(20) | SQL plan ID; created by Surveillance (based on SQL plan handle) |
| seqno | double | Sequence # of XML text fragment |
| query_plan | string(1024) | XML text fragment of SQL plan |
| Attributes: | DMV |
|---|---|
| Minimum database version: | 10.0 |