Number of extents for table SYSPROCBODY

Posted in 1999

Andrzej Kurowski — Tue, 18 May 1999 14:19:01 +0200 — source: Informix-list mailing list archive (1991-1998)

Hi, I have 272 extents for table "SYSPROCBODY". How can I reduce number of extents for system tables? Andrzej Kurowski

↪ replying to Andrzej Kurowski

Art S. Kagel — Wed, 19 May 1999 17:24:28 -0400 — source: Informix-list mailing list archive (1991-1998)

Andrzej Kurowski wrote: > > Hi, > I have 272 extents for table "SYSPROCBODY". > How can I reduce number of extents for system tables? No and don't worry about it active stored procedures are cached in memory in the Stored Procedure Cache which you can increase using the undocumented ONCONFIG parameters PC_POOLSIZE and PC_HASHSIZE (Must be prime) if you have a more than about 500 active stored procedures. Art S. Kagel