Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Timed_statistics, True or False
I agree with Winnie that timed_statistics should be turned on. In fact I
think Oracle should just turn on statistics by default and not making the
timed_statistics parameter available. I think Oracle has made many init.ora
parameters available which on one hand giving us DBAs the power to
manipulate the system performance and on the other hand making the system
more complex than necessary and making our job harder.
Long
-----Original Message-----
From: Rachel Carmichael [mailto:carmichr_at_hotmail.com]
Sent: Saturday, 19 August 2000 12:24 PM
To: Multiple recipients of list ORACLE-L
Subject: 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).
-- Author: Rachel Carmichael INET: carmichr_at_hotmail.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-LReceived on Mon Aug 21 2000 - 19:19:26 CDT