COMMANDCACHESTATISTICSRESET

Definition

The system table COMMANDCACHESTATISTICSRESET contains statistical information about the activities of the command cache 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 deletes

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

See also:

COMMANDCACHESTATISTICS