Re: Fragmented Table
I wouldn't worry too much about this, expecially if this is DSA.
In DSA, we maintain a cache of procedures which we use to contain the
"compiled" version of the procedure. Since entries in this cache pool are
aged by usage, the ones that are used a lot tend to remain in the pool,
while the ones not used that much might have to be reloaded from time to
time.
Check onstat -g prc to monitor this.
Madison Pruet