sa_diagnostic_cursor table

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.