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.
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. |