Parameter
dbs/mss/pn_cache_size

Short text
size of name cache for permanent stored procedurThe number of permanent stored procedure in the name cache.Typically set it to at least as large as the number of Y* storedprocedures in the database. Monitor this value using the msstats inst04 and increase the value if you see swaps.

Work area
Database

Parameter unit
integer

Default value
10000

Limitation for os
Windows NT

Limitation for db
Microsoft SQL Server