RE: FW: Timed_statistics, True or False

I haven't seen it on them.. I've been told that under HP-UX you CAN see degradation of up to 12%.....

Hm, gonna have to check this out now.

Rachel

>From: "Adams, Matthew (GEA, 088130)" <MATT.ADAMS_at_APPL.GE.COM>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: RE: FW: Timed_statistics, True or False
>Date: Tue, 22 Aug 2000 05:38:34 -0800
>
> Rachel,
>
> I've got about 50 HP-UX servers running Oracle
>at the moment. I've noticed no significant
>performance degradation by turning on
>timed_statistics.
>
>What versions of OS/Oracle did you see these problems
>on?
>
>Matt Adams
>
>"Send lawyers, guns and money." - warren zevon
>
>-----Original Message-----
>To: Multiple recipients of list ORACLE-L
>Sent: 8/21/00 10:47 PM
>
>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).
>
>________________________________________________________________________
>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).
>--
>Author: Adams, Matthew (GEA, 088130)
> INET: MATT.ADAMS_at_APPL.GE.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
Received on Tue Aug 22 2000 - 10:53:48 CDT