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).