Re: timed statistics
Date: Wed, 7 Dec 1994 23:36:37
Message-ID: <singerap.36.00179CEE_at_powergrid.electriciti.com>
In article <D0G7FD.7An_at_ottnews.shl.com> mbelle_at_ottnews.shl.com (Marc Bellefeuille) writes:
>From: mbelle_at_ottnews.shl.com (Marc Bellefeuille)
>Subject: timed statistics
>Date: Wed, 7 Dec 1994 16:06:48 GMT
>Hi there!
>I am wondering if when setting the init.ora parameter "timed_statistics"
>to "TRUE" has a major impact on performance.
>Does anyone have some experience as to what percentage of performance loss
>I would get if I set this init.ora parameter to true?
>Could you respond via e-mail because our news feed has been quite slow of
>late.
I cannot tell you exacty how much slow it made thing. However, I can tell you it was quit noticable. I could not recomed this for production database. When I tund timed statistics on the users said every thing ran four times slower. This was on a Sequent system with 6 processors.
>Thanks a bunch
>Marc Bellefeuille
>SHL Systemhouse
>Ottawa, Ontario
>email: mbelle_at_ottnews.shl.com
Received on Wed Dec 07 1994 - 23:36:37 CET