Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> FW: Timed_statistics, True or False
Rachel,
How about Sun Solaris?
Lucia
-----Original Message-----
From: carmichr_at_hotmail.com [mailto:carmichr_at_hotmail.com]
Sent: Friday, August 18, 2000 7:24 PM
To: ORACLE-L_at_fatcity.com
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-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). --- Internet Message Header Follows --- Received: from newsfeed.cts.com (209.68.192.199) by prophet.com (FirstClass Mail Server v5.11) transient id 1025; 6:54:43 PM -0800 Received: from fatcity.UUCP (uucp_at_localhost) by newsfeed.cts.com (8.9.3/8.9.3) with UUCP id SAA28609; Fri, 18 Aug 2000 18:46:34 -0700 (PDT) Received: by fatcity.com (04-May-2000/v1.0f-b69/bab) via UUCP id 001ACBC9; Fri, 18 Aug 2000 18:24:08 -0800 Message-ID: <F001.001ACBC9.20000818182408_at_fatcity.com> Date: Fri, 18 Aug 2000 18:24:08 -0800 To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> X-Comment: Oracle RDBMS Community Forum X-Sender: "Rachel Carmichael" <carmichr_at_hotmail.com> Sender: root_at_fatcity.com Reply-To: ORACLE-L_at_fatcity.com Errors-To: ML-ERRORS_at_fatcity.com From: "Rachel Carmichael" <carmichr_at_hotmail.com> Subject: Re: Timed_statistics, True or False Organization: Fat City Network Services, San Diego, California X-ListServer: v1.0f, build 69; ListGuru (c) 1996-2000 Bruce A. BergmanReceived on Mon Aug 21 2000 - 19:56:09 CDT