Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Performance penalty when turn on timed_statistics
"Ken Chung" <chungcck_at_netvigator.com> wrote in message news:<9f4plf$9bq99_at_imsp212.netvigator.com>...
> 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.
>
>
> Regards,
> Ken
This another commonly misunderstood concept about Oracle. Oracle collects statistics anyway. The only difference is updating the system views or not. So you can ignore the performance overhead if exists.
Sincerely,
Bass Chorng Received on Thu May 31 2001 - 16:05:11 CDT