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
>
>
>
>

I have never seen any noticeable impact. Keep in mind, most of these statistics are gathered anyway, and the only difference you now keep track of the time.
I have also read several times you should enable it always, and I have never seen warnings against it.

Hth,

Sybrand Bakker, Oracle DBA Received on Thu May 31 2001 - 03:09:17 CDT