Stored Procedures

Problem: How to Increase the Cache.

I have a lot of stored procedures and the stored procedure cache is limited to 50. Can I increase it so that more of stored procedures are cached?

Solution: PC_POOLSIZE

Insert the parameter PC_POOLSIZE into the ONCONFIG file and set it to whatever number you like. This parameter is not usually in the ONCONFIG file, but it defaults to 50.