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