Timed statistics has very little performance impact - most of the work is
already done internally anyway. It is very useful - for tkprof, wait
statistics, and a few other things. I always set it and have for years -
even on exceptionally hot OLTP systems. A guy I know from the Oracle Center
of Expertise gave a talk to our local user group two weeks ago and mentioned
that he had never seen any noticeable performance degradation due to setting
it. If there is any significant performance impact, you have much bigger
problems than timed statistics.
I have seen only one very specific bug related to setting it. That was just
recently after upgrading an 8.1.7.0.0 OPS database on Sun Solaris to
8.1.7.1.0. Prior to the upgrade, no problem. After the upgrade, shutting
down an instance while in parallel mode resulted in a long wait (several
additional minutes, even with immediate) and an ORA-07445 error that
generated a trace file and a cdump. The problem is that one of the OPS
processes, bsp, would not shut down cleanly. This is one of the last things
that happens during the instance shutdown. Since the database had already
been dismounted, it probably isn't that serious. As far as I know, it only
happens with PARALLEL_SERVER=TRUE in 8.1.7.1.0 (on Sun Solaris at least) and
it did not happen in any prior release/patchlevel of 8i.
-Don Granaman
[certifiable OraSaurus]
----- Original Message -----
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, June 20, 2001 10:16 AM
> Hi
>
> Has anyone experienced any problems after setting timed_statistics to true
> on a prod database (at system level) ?
>
> Can anyone give me a guess as to the performance hit of doing this ?
>
> Running Oracle 8.1.6, there are fairly predictable periods of high,
medium,
> and low load so I can avoid collecting stats at peak periods if necessary.
>
> Cheers
> Greg
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Greg Solomon
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Don Granaman
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
