Re: FW: Timed_statistics, True or False

I've also heard of nothing specific to HP-UX, but there is a specific issue for the 8.1.5 server. Setting timed statistics and using sql trace causes excessive parsing (due to no cursor caching). This has been fixed in 8.1.6.

Regards,
Chris Gait

On 21 Aug 2000, at 18:34, Joseph S. Testa wrote:

> 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
> > also send the HELP command for other information (like subscribing).
>
> --
> Joe Testa http://www.oracle-dba.com
> Oracle 8i documentation online http://www.oracle-dba.com/oracle-docs
> --
> Author: Joseph S. Testa
> INET: teci_at_oracle-dba.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
Received on Tue Aug 22 2000 - 13:55:24 CDT