Summary information |
|
|---|---|
Default value |
3271 |
Range of values |
3271 – 2147483647 |
Status |
Dynamic |
Display level |
Basic |
Required role |
System Administrator |
Specifies the size of the procedure cache in 2K pages. Adaptive Server uses the procedure cache while running stored procedures. If the server finds a copy of a procedure already in the cache, it does not need to read it from the disk. Adaptive Server also uses space in the procedure cache to compile queries while creating stored procedures.
Since the optimum value for procedure cache size differs from application to application, resetting it may improve Adaptive Server’s performance. For example, if you run many different procedures or ad hoc queries, your application uses the procedure cache more heavily, so you may want to increase this value.
WARNING! If procedure cache size is too small, Adaptive Server’s performance will be greatly affected.
If you are upgrading, procedure cache size is set to the size of the original procedure cache at the time of upgrade. procedure cache size is dynamically configurable, subject to the amount of max memory currently configured.
