RE: Timed_statistics, True or False

I believe the feature to set stats on at system leverl was added in = version 8.0, and definitely available in version 8.1.

>>> lbarbour_at_stanford.edu 08/22/00 11:44AM >>>
I believe if you want to set timed_statistics on for everyone, you have = to=20
do that through the initialization parameters. But you can set it for = your=20
session.

ALTER SESSION SET TIMED_STATISTICS=3DFALSE; 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 =3D false ;
>
>and got the following error :
>
>alter system set timed_statistics =3D 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]=20
> > 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=20
> > >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=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.co=
m=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: Weerd Kirsten, E.C. de
> INET: Kirsten.deWeerd_at_Oranjewoud.nl=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
Received on Tue Aug 22 2000 - 11:53:50 CDT