COMMANDCACHESTATISTICSRESET

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