timed_statistics on solaris is fine.
joe
Lucia DeMeester wrote:
>
> 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
Received on Mon Aug 21 2000 - 20:36:08 CDT
