Hi,
I am trying to understand what invalidates Dynamic Packages in the
Package Cache.
By monitoring the Size of the Package Cache, it appears the following
does
1. Performing a Runstats on all Tables reduces the Used Package Cache
from some 200+MB to about 30MB ??
2. Performing a Refresh of an MQT appears to cause some packages to be
recompiled?
This is causing us pain as we have some Dynamic packages that take
considerable time (10secs +) to compile and so it is imperative we hold
them in the package cache.
Can anybody inform us what will invalidate Dynamic Packages - and if
our observations are correct?
Many Thanks.
Paul