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 | Column constraint | Table constraints |
---|---|---|---|
logging_session_id | UNSIGNED INT | NOT NULL |
Primary key. Foreign key references sa_diagnostic_query. |
cursor_id | UNSIGNED BIGINT | NOT NULL |
Primary key. |
query_id | UNSIGNED BIGINT | NOT NULL |
Foreign key references sa_diagnostic_query. |
isolation_level | TINYINT | ||
flags | UNSIGNED INT | ||
forward_fetches | UNSIGNED INT | ||
reverse_fetches | UNSIGNED INT | ||
absolute_fetches | UNSIGNED INT | ||
first_fetch_time_ms | UNSIGNED INT | ||
total_fetch_time_ms | UNSIGNED INT | ||
plan_xml | LONG VARCHAR |
logging_session_id A number uniquely identifying the logging session during which the diagnostic information was gathered.
cursor_id A unique number identifying the cursor.
query_id Identifies the query over which this cursor ranges.
isolation_level Isolation level at which this cursor was opened.
flags Internal use.
forward_fetches Number of forward fetches, including prefetches, done on the cursor.
reverse_fetches Number of reverse fetches, including prefetches, done on the cursor.
absolute_fetches Number of absolute fetches done on the cursor.
first_fetch_time_ms Duration of time spent fetching the first row.
total_fetch_time_ms Duration of time spent fetching. This value does not include application processing time between actual fetches (think time).
plan_xml 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. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |