Re: Timed_statistics, True or False

Winnie,

With one notable exception you are right. For some reason, on HP-UX systems, turning on timed_statistics can cause a performance degradation that is noticeable (I've heard up to 12%)

Rachel

>From: Winnie_Liu_at_infonet.com
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: Re: Timed_statistics, True or False
>Date: Fri, 18 Aug 2000 17:07:01 -0800
>
>
>From all my past experience, the impact of turning the timed_statistics on
>in the system is minimal.
>
>And for performance tuning reason, I believe all DBA should turn this
>parameter to TRUE.
>
>Winnie
>
>
>
>
>
>Gillian M <zmkj04_at_yahoo.com> on 08/18/2000 04:18:02 PM
>
>Please respond to ORACLE-L_at_fatcity.com
>
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>cc: (bcc: Winnie Liu/HQ/ISC)
>
>
>
>
>
>From what I understand, with timed_stats on, it
>becomes resource intensive.
>
>You might want to set it only when you are
>troubleshooting.
>
>G!
>--- Linda Hagedorn <Linda_at_pets.com> wrote: > Hello,
> >
> > My searches in Metalink show timed_statistisc=True
> > is the recommended
> > setting. I'm hearing that some Oracle classes
> > recommend keeping
> > timed_statistics=False unless you are tracing.
> >
> > Other than, 'It depends', what do you have your
> > statistics set for?
> >
> > We have SQL_TRACE on all the time. I'd prefer
> > having timed_statistics=true
> > so I can grep for the total line in a large number
> > of tkprof output files,
> > and selectively find the long-running transactions.
> >
> > Any opinions are welcome.
> >
> > Thanks,
> >
> > Linda Hagedorn
> >
> >
> > --
> > Author: Linda Hagedorn
> > INET: Linda_at_pets.com
> >
> > 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: ListGuru_at_fatcity.com (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).
>
>
>__________________________________________________
>Do You Yahoo!?
>Send instant messages & get email alerts with Yahoo! Messenger.
>http://im.yahoo.com/
>--
>Author: =?iso-8859-1?q?Gillian=20M?=
> INET: zmkj04_at_yahoo.com
>
>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: ListGuru_at_fatcity.com (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).
>
>
>
>
>
>
>--
>Author:
> INET: Winnie_Liu_at_infonet.com
>
>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: ListGuru_at_fatcity.com (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).