Re: Changing the Stored Procedure Cache (PC_POOLSIZE)

David Williams wrote: > > In article <859052869.29347.1@basharlp.ctl.com>, Bashar Chalabi > <bashar@ctl.com> writes > >Hi there, > > > >We have ODS 7.10 on SCO OSR5. > > > >We tried changing the PC_POOLSIZE parameter to increase the size of the stored > >procedure cache. The > >performance gains are fairly dramatic. However, we now have an unstable system. > >Every once in a while, we > >get a: > > > >Assert Failed: Internal Error - Segmentation Violation.> > > >By removing PC_POOLSIZE from onconfig, we get a stable system. > > > >Can anybody help? Any reason why PC_POOLSIZE is not the manuals? > Because it is not supported..there are several of these parameters > which are not documented. I've heard, PC_POOLSIZE is an undocumented but supported parameter. So I think it's a good idea to contact your technical support. > I suspect they are only used by the Informix > development team when making decisions about how Informix should work > internally in a particular port. i.e. when tuning a port of Informix > they change these to deciede what the default values should be, then > hardcode these as the detauls and make sure Online works correctly with > these values.... > > > > >Thanks > > > >Bashar Chalabi > >Card Tech Ltd > > > > -- > David Williams -- Stefan