Re: TBLSPACE_STATS to turn off/on?

"Art S. Kagel" wrote: > > You will indeed lose the onstat -g ppf output but the overhead associated > with TBLSPACE_STATS is not insignificant. I have NEVER had this parameter > set through the four versions that have supported it and have never had any > memory corruption or other problems that were traced to this facility. > > My recommendation? Keep it off unless you suspect some bottleneck then > turn it on for a reasonable period, say a week to gather stats then off > again after analysis. Mmmm, I'll throw my 2c in here. I NEVER turn off TBLSPACE_STATS, because I use the stats a lot. Also I seem to work with a lot of 24 hour operations, where asking to quickly bounce the engine to change some parameters is met with looks of confusion and comments like, "didn't we already do that last year?" When it comes to diagnosing performance issues, I like to have those stats available, even at the cost of a little performance. I REALLY look forward to the day when ALL parameters can be changed on the fly. :-) Cheers, -- Mark. +----------------------------------------------------------+-----------+ | Mark D. Stock mailto:mdstock@mydas.freeserve.co.uk |//////// /| | http://www.informix.com http://www.informixhandbook.com |///// / //| | http://www.iiug.org +-----------------------------------+//// / ///| | |This email will self-destruct in |/// / ////| | |10 sec. If you received this email |// / /////| | |in error, sorry about the mess. |/ ////////| +----------------------+-----------------------------------+-----------+