monStatementCache

Description

Provides statistical information about the statement cache. You must enable the statement cache before monStatementCache table can collect data.

Enable the enable monitoring, enable stmt cache monitoring, and statement cache size configuration parameters for this monitoring table to collect data.

Columns

The columns for monStatementCache are:

Name	Type	Attributes	Description
InstanceID	tinyint		(Cluster environments only) ID of an instance in a shared-disk cluster.
TotalSizeKB	int		Configured size, in KB, of the statement cache.
UsedSizeKB	int		Amount of the statement cache, in KB, currently in use.
NumStatements	int		Number of statements in the statement cache.
NumSearches	int	Counter, reset	Number of times the statement cache was searched.
HitCount	int	Counter, reset	Number of times the statement cache was searched and a match was found.
NumInserts	int	Counter, reset	Number of statements that were inserted into the statement cache.
NumRemovals	int	Counter, reset	Number of times statements were removed from the statement cache. This value includes statements that were removed with explicit purges or from a replacement strategy.
NumRecompilesSchemaChanges	int	Counter, reset	Number of recompiles due to schema changes in the tables referred to in the cached statements.
NumRecompilesPlanFlushes	int	Counter, reset	Number of recompiles due to the plan flushes from the cache.