Re: Number of extents for table SYSPROCBODY

Posted in 1999

Mark D. Stock — Thu, 20 May 1999 11:44:40 +0200 — source: Informix-list mailing list archive (1991-1998)

"Art S. Kagel" wrote: > > 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. 50! Unless the default has increased recently. Cheers, -- Mark. +----------------------------------------------------------+-----------+ |Mark D. Stock - Informix SA http://www.informix.com |//////// /| |mailto:mdstock@informix.com http://www.informix.com/idn |///// / //| |http://www.iiug.org +-----------------------------------+//// / ///| | Tel: +27 11 807 0313 |What year 2000 bug? year 2000 bug? |/// / ////| | Fax: +27 838250 2325 |year 2000 bug? year 2000 bug? year |// / /////| |Cell: +27 83 250 2325 |2000 bug? year 2000 bug? year 2000 |/ ////////| +----------------------+-----------------------------------+-----------+