Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » SQL Anywhere Server - SQL Reference » Tables » Diagnostic tracing tables

sa_diagnostic_connection table Next Page

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.

Columns
Column name Column type Column constraint Table constraints
logging_session_idUNSIGNED INTNOT NULL

Primary key.

Foreign key references sa_diagnostic_query.

cursor_idUNSIGNED BIGINTNOT NULL

Primary key.

query_idUNSIGNED BIGINTNOT NULL

Foreign key references sa_diagnostic_query.

isolation_levelTINYINT
flagsUNSIGNED INT
forward_fetchesUNSIGNED INT
reverse_fetchesUNSIGNED INT
absolute_fetchesUNSIGNED INT
first_fetch_time_msUNSIGNED INT
total_fetch_time_msUNSIGNED INT
plan_xmlLONG 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.

See also