RE: TBLSPACE_STATS
Hi,
In the machine notes for ids 9 I find the next text:
"16. In this release, partition profiling can be disabled by setting a new
configuration parameter, TBLSPACE_STATS, to 0 in the onconfig file.
When TBLSPACE_STATS is set to 0, the output of onstat -g ppf will
read "Partition profiles disabled".
Disabling the partition profiling will result in fewer cache
invalidations and less bus traffic due to fewer updates to the
partition structure in the shared memory. This feature benefits
especially the NUMA systems, since disabling partition profiling will
reduce intra-quad memory updates.
By default, the value of this parameter is 1 (collection of partition
statistics enabled), as with earlier versions of Informix server
products."
I hope this help you.
Gustavo Tobares
Administrador de Sistemas y DBA
Centro de Computos - Red Megatone
TE: 0342-4500972 - Fax: 0342-4500940
-----Mensaje original-----
De: rkusenet [mailto:rkusenet@sympatico.ca]
Enviado el: Martes, 17 de Junio de 2003 06:40 p.m.
Para: informix-list@iiug.org
Asunto: TBLSPACE_STATS
How much performance degradation can be expected if I turn
TBLSPACE_STATS ON (=1).
Thanks.
Ravi
sending to informix-list