RE: Timed_statistics, True or False

Hey all,

Thanx for the information all. I'm just gonna leave it on. I need the timing to frequently, and if it can't be turned on or off without bouncing the DB, it's just not handy.

One comment I would like to make however :

Unless someone performed a huge operation, which I should definately have noticed this morning, I'm still male. Just thought I'd let you in on that little secret :-)

Greets,

Kirsten

> -----Original Message-----
> From: Rachel Carmichael [SMTP:carmichr_at_hotmail.com]
> Sent: Tuesday, August 22, 2000 6:15 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Timed_statistics, True or False
>
> in 7.3.4 timed_statistics is listed as "issys_modifiable" immediate...
> which
> means you can alter at the system level.
>
> She is running 7.2.3, you can't modify the init.ora parameters without
> bouncing the database in that version.
>
>
> >From: Lyall Barbour <lbarbour_at_stanford.edu>
> >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: Tue, 22 Aug 2000 07:44:32 -0800
> >
> >I believe if you want to set timed_statistics on for everyone, you have
> to
> >do that through the initialization parameters. But you can set it for
> your
> >session.
> >
> >ALTER SESSION SET TIMED_STATISTICS=FALSE;
> >
> >should do the trick.
> >
> >Good luck,
> >Lyall Barbour
> >
> >At 03:07 AM 8/22/00 -0800, you wrote:
> >>Hi,
> >>
> >>I just did a :
> >>
> >>alter system set timed_statistics = false ;
> >>
> >>and got the following error :
> >>
> >>alter system set timed_statistics = false
> >> *
> >>ERROR at line 1:
> >>ORA-02065: illegal option for ALTER SYSTEM
> >>
> >>Running Oracle 7.2.3 on HP-UX 10.20
> >>Is this not a dynamic option ???
> >>
> >>Greets,
> >>
> >>Kirsten
> >>
> >> > -----Original Message-----
> >> > From: Rachel Carmichael [SMTP:carmichr_at_hotmail.com]
> >> > Sent: Tuesday, August 22, 2000 11:08 AM
> >> > To: Multiple recipients of list ORACLE-L
> >> > Subject: RE: Timed_statistics, True or False
> >> >
> >> > You lose some statistical information, useful in finding performance
> >>and
> >> > other problems. So.... if you turn it off (and you should on HP-UX),
> >>and
> >> > you
> >> > have a problem, you would turn it on, wait for the problem to
> re-occur
> >> > (and
> >> > do bstat/estat and investigation) and turn it off.
> >> >
> >> > So in effect, if you have problems, it will take you somewhat longer
> >> > (possibly) to resolve them
> >> >
> >> > In your case, I would turn it off.
> >> >
> >> >
> >> > Rachel
> >> >
> >> >
> >> > >From: "Weerd Kirsten, E.C. de" <Kirsten.deWeerd_at_Oranjewoud.nl>
> >> > >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: Mon, 21 Aug 2000 23:36:38 -0800
> >> > >
> >> > >I'm running Oracle 7.2.3 on HP-UX 10.20 and frankly don't like the
> >>idea
> >> > of
> >> > >a
> >> > >possible performance degradation of 12% because of one parameter set
> >> > TRUE.
> >> > >
> >> > >But, new as I still am, can anyone tell me : What exqctly do I loose
>
> >>when
> >> > >turning this timed_statistics to FALSE ???
> >> > >
> >> > >Thanx for the info.
> >> > >
> >> > >Greets,
> >> > >
> >> > >
> >> > >Kirsten
> >> > >
> >> > > > -----Original Message-----
> >> > > >
> >> > > > 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
> >> > > >
> >> > >--
> >> > >Author: Weerd Kirsten, E.C. de
> >> > > INET: Kirsten.deWeerd_at_Oranjewoud.nl
> >> > >
> >> > >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: Weerd Kirsten, E.C. de
> >> INET: Kirsten.deWeerd_at_Oranjewoud.nl
> >>
> >>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
Received on Wed Aug 23 2000 - 02:17:26 CDT