Re: Performance penalty when turn on timed_statistics

On Thu, 31 May 2001 14:56:45 +0800, "Ken Chung" <chungcck_at_netvigator.com> wrote:

>Have anyone test/know the performance impact of setting timed_statistics
>to true. One told me that it does affect the performance too much.
>However, some books said that never turn on timed_statistics to true
>on production environments. It will slow down the database.
>

There appears to be a bug somewhere in 8.1.x that may cause serious slowdown of the database if timed_statistics are on. It's in Metalink, can't remember the number. Hope it's fixed by now!

Nowhere else has it ever affected squat on any database I've run it on. In fact, much of the gathering of info for proper tuning of the db cannot happen without it on.

Cheers
Nuno Souto
nsouto_at_bigpond.net.au.nospam
http://www.users.bigpond.net.au/the_Den/index.html Received on Thu May 31 2001 - 06:11:55 CDT