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_blocking table Next Page

sa_diagnostic_cachecontents table


The sa_diagnostic_cachecontents table is owned by the dbo user. When diagnostic tracing is enabled, periodic snapshots of the cache contents are taken. The sa_diagnostic_cachecontents table records the number of table pages for each table in the cache at the time the snapshot was taken, as well as the number of rows in each table. The optimizer can use this information to recreate the conditions under which a query was originally optimized, and then make optimization decisions.

Data in the sa_diagnostic_cachecontents table is updated every 20 seconds, as long as there is query activity.

There are two versions of this table: sa_diagnostic_cachecontents, and sa_tmp_diagnostic_cachecontents.

Columns
Column name Column type Column constraint Table constraints
logging_session_idUNSIGNED INTNOT NULL
"time"TIMESTAMPNOT NULLPrimary key.
original_table_object_idUNSIGNED BIGINTNOT NULLPrimary key.
pages_in_cacheUNSIGNED INTNOT NULL
num_table_pagesUNSIGNED INTNOT NULL
num_table_rowsUNSIGNED BIGINTNOT NULL

logging_session_id    A number uniquely identifying the logging session during which the diagnostic information was gathered.

"time"    The time at which the snapshot of the cache was taken.

original_table_object_id    The object ID of each table represented in the snapshot.

pages_in_cache    For a specified table in the snapshot, the total number of pages in cache at the moment of the snapshot.

num_table_pages    For a specified table in the snapshot, the total number of pages for the table.

num_table_rows    For a specified table in the snapshot, the total number of rows in the table.