Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: FW: Timed_statistics, True or False

RE: FW: Timed_statistics, True or False

From: Tim Sawmiller <sawmillert_at_state.mi.us>
Date: Tue, 22 Aug 2000 12:51:26 -0400
Message-Id: <10597.115254@fatcity.com> 





Yes, there usually SOME degradation.  My group's general recommendation is =
to keep stats off, turning them on dynamically when the need arises.



Tim Sawmiller


Senior Principal Consultant


Central Performance Architecture


Oracle Corp.








"Statements are my own and not necessarily those  of Oracle Corp."



>>> carmichr_at_hotmail.com 08/22/00 12:55PM >>>

I haven't seen it on them.. I've been told that under HP-UX you CAN see=20
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=20

>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 =3D 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=20

> >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=20

> >

> >

> >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=20

> > >>Reply-To: ORACLE-L_at_fatcity.com=20

> > >>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=20

> > >>

> > >>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=3DTrue

> > >> > is the recommended

> > >> > setting.  I'm hearing that some Oracle classes

> > >> > recommend keeping

> > >> > timed_statistics=3DFalse 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=3Dtrue

> > >> > 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=20

> > >> >

> > >> > 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/=20

> > >>--

> > >>Author: =3D?iso-8859-1?q?Gillian=3D20M?=3D

> > >>   INET: zmkj04_at_yahoo.com=20

> > >>

> > >>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=20

> > >>

> > >>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=20

> >

> >--

> >Author: Rachel Carmichael

> >   INET: carmichr_at_hotmail.com=20

> >

> >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=20

> >Reply-To: ORACLE-L_at_fatcity.com=20

> >Errors-To: ML-ERRORS_at_fatcity.com=20

> >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=3Dflowed

> >Content-Transfer-Encoding: 7bit

> >

> >--

> >Author: Lucia DeMeester

> >   INET: ldemeester_at_nm2.com=20

> >

> >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=

=20


>

>--

>Author: Rachel Carmichael

>   INET: carmichr_at_hotmail.com=20

>

>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=20


>

>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=20=




--=20


Author: Rachel Carmichael


  INET: carmichr_at_hotmail.com=20


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
Received on Tue Aug 22 2000 - 11:51:26 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US