Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Performance penalty when turn on timed_statistics

Re: Performance penalty when turn on timed_statistics

From: Bass Chorng <bchorng_at_yahoo.com>
Date: 31 May 2001 14:05:11 -0700
Message-ID: <bd9a9a76.0105311305.16ef810b@posting.google.com>

"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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US