LUW 9.1 FP4a

Hey all,

I'm seeing my package cache hit ratio dropping to 60-70% from time to time but I have STMM on and the PCKCACHESZ = AUTOMATIC. Now when I check it the cfg says it's constantly at 524288 (which is the maximum value!!). I figure that to be 2GB, which roughly means the package cache must need about 3GB during certain times, yea?

Now my entire database is only about 20GB... does this not add up to you guys either?

Try to change some of the major queries fired too often to be dynamic/Parametized

If your queries are not parameterized, then it doesn't matter how big your package cache is ... every statement has to be prepared and inserted into the cache ...