The sa_diagnostic_cursor table is owned by the dbo user. Each row describes either an internal or external cursor opened during the logging session.
There are two versions of this table: sa_diagnostic_cursor, and sa_tmp_diagnostic_cursor.
Column name | Column type | Description |
---|---|---|
logging_session_id | UNSIGNED INT |
A number uniquely identifying the logging session during which the diagnostic information was gathered. |
cursor_id | UNSIGNED BIGINT |
A unique number identifying the cursor. |
query_id | UNSIGNED BIGINT |
Identifies the query over which this cursor ranges. |
isolation_level | TINYINT |
Isolation level at which this cursor was opened. |
flags | UNSIGNED INT |
Internal use. |
forward_fetches | UNSIGNED INT |
Number of forward fetches, including prefetches, done on the cursor. |
reverse_fetches | UNSIGNED INT |
Number of reverse fetches, including prefetches, done on the cursor. |
absolute_fetches | UNSIGNED INT |
Number of absolute fetches done on the cursor. |
first_fetch_time_ms | UNSIGNED INT |
Duration of time spent fetching the first row. |
total_fetch_time_ms | UNSIGNED INT |
Duration of time spent fetching. This value does not include application processing time between actual fetches (think time). |
plan_xml | LONG VARCHAR |
Detailed plan for cursors that were dumped at the time the cursor was closed. These plans contain detailed statistics where appropriate. |
Discuss this page in DocCommentXchange.
|
Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0 |