Re: Performance penalty when turn on timed_statistics

Thanks for all the kindly replies.

Actually, I'm supporting a pair of Oracle instances running on Solaris Cluster (E450).
One database instance db1 on machine m1 was failed over to another machine m2.
Resulting in both db1 and db2 running on m2. I'm investigating the caused of problem ... and found that the some clients report that query was slow down quickly on db1 before the fail over.

According to the original design, the workload on db1 is greater than that on db2.
And timed_statistics was set to true for both database instances. I suspect that the performance on db1 deteriorate in about 2 to 3 months period,
and then fail over to m2.
Is this a likely case?

Regards,
Ken Received on Thu May 31 2001 - 12:00:36 CDT