Re: FW: Timed_statistics, True or False

there is very slight degradation of performance on all platforms if you set timed_statistics = true but not enough to make it detrimental to keep it on.

Only HP-UX has the significant degradation, that I know of.

Rachel

>From: "Lucia DeMeester" <ldemeester_at_nm2.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: FW: Timed_statistics, True or False
>Date: Mon, 21 Aug 2000 18:04:13 -0800
>
>Rachel,
>
>How about Sun Solaris?
>
>Lucia
>
>-----Original Message-----
>Sent: Friday, August 18, 2000 7:24 PM
>To: ORACLE-L_at_fatcity.com
>
>
>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).
>
>________________________________________________________________________
>Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
>
>--
>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
>Organization: Fat City Network Services, San Diego, California
>X-ListServer: v1.0f, build 69; ListGuru (c) 1996-2000 Bruce A. Bergman
>Precedence: bulk
>Mime-Version: 1.0
>Content-Type: text/plain; format=flowed
>Content-Transfer-Encoding: 7bit
>
>--
>Author: Lucia DeMeester
> INET: ldemeester_at_nm2.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).
Received on Mon Aug 21 2000 - 20:33:46 CDT