| STMT_CACHE_HITS hits |
Specifies the number of hits (references)
to a statement before it is fully inserted in the SQL statement cache
Set hits to 1 or more to exclude ad hoc queries
from entering the cache. |
You can only increase or reset the value of STMT_CACHE_HITS.
The new value displays in the #hits field of the onstat-g ssc output. If hits =
0, the database server inserts all qualified statements and its memory structures
in the cache. If hits > 0 and the number of
times the SQL statement has been executed is less than STMT_CACHE_HITS,
the database server inserts key-only entries in the
cache. It inserts qualified statements in the cache after the specified number
of hits have been made to the statement. ONCONFIG Parameter:
STMT_CACHE_HITS |
| STMT_CACHE_NOLIMIT value |
Controls whether statements are inserted in the SQL
statement cache when its size is greater than the STMT_CACHE_SIZE value |
If value = 0, the database
server inserts statements in the cache when its size is greater than the value
of STMT_CACHE_SIZE. If value = 1, the database server
always inserts statements in the cache. If none of the queries are shared,
turn off STMT_CACHE_NOLIMIT to prevent the database server from allocating
a large amount of memory for the cache.ONCONFIG Parameter:
STMT_CACHE_NOLIMIT |
