Re: PC_POOLSIZE

Nick Miles wrote: > > Does anyone know how much memory is being used by the default Procedure > Cache? I'd like to increase the PC_POOLSIZE, but I'd feel more > comfortable knowing exactly what affects this will have. > > I've done some testing with PC_POOLSIZE, and the procedure cache always > keeps (PC_POOLSIZE/2 - 1) procedures in the cache, regardless of stored > procedure size! Does this mean that the virtual stored memory usage is > completely variable? Yes. PC_POOLSIZE just allocates a fixed array of cache headers the actual space used by the procedures and their query path data are allocated dynamically. Art S. Kagel