Object documentationCOMMANDCACHESTATISTICSRESET Locate this document in the navigation structure

 

The system table SYSINFO.COMMANDCACHESTATISTICSRESET contains the statistical information collected about the command cache activities since the last RESET COMMANDCACHESTATISTICS or RESET ALL. The command cache contains the SQL statements and their execution plans shared by different database sessions (the following refers to the SQL statement and execution plan collectively as a command).

Structure

COMMANDCACHESTATISTICSRESET

RESETDATE

TIMESTAMP

Time of the last RESET for these entries

USABLESIZE

FIXED(10)

Size of the command cache (KB)

MAXUSEDSIZE

FIXED(10)

Maximum used area of the command cache (KB)

MAXUSEDSIZEPERCENTAGE

FIXED(3)

Maximum used area of the command cache (%)

MAXCOMMANDCOUNT

FIXED(10)

Maximum number of stored commands

INSERTCOMMANDCOUNT

FIXED(10)

Number of inserts

DELETECOMMANDCOUNT

FIXED(10)

Number of deletions

FAILEDALLOCATECOUNT

FIXED(10)

Number of memory requests not fulfilled

CLEANUPCOUNT

FIXED(10)

Number of operations that encountered a lack of space in the main memory

CLEANUPCOMMANDCOUNT

FIXED(10)

Number of commands modified due to lack of space in the main memory

INVALIDATECOUNT

FIXED(10)

Number of data definition statements that made execution plans invalid

UNLOADSTATEMENTCOUNT

FIXED(10)

Number of SQL statements displaced to disk

RELOADSTATEMENTCOUNT

FIXED(10)

Number of SQL statements reloaded to the main memory

DELETEPLANCOUNT

FIXED(10)

Number of execution plans deleted due to lack of space in the main memory

MAXUSEDHASHTABLESLOTCOUNT

FIXED(5)

Maximum number of used slots in the hash table

MAXHASHTABLECHAINENTRYCOUNT

FIXED(5)

Maximum length of the hash entry overflow chains

More Information

COMMANDCACHESTATISTICS